Hi there folks,

I need to select the rows which have the TIMESTAMP field value more
than X minutes ago from the current moment.

SELECT * FROM VISIT_DETAIL
WHERE (CHECKOUT_TIMESTAMP IS NULL) AND (CHECKIN_TIMESTAMP
<= :CHECKIN_TIMESTAMP)

and then i popuplate the query parameter in Delphi application

FQuery.ParamByName('CHECKIN_TIMESTAMP').AsDateTime := Now - X/(24*60);

Looks like something is wrong with this.

Whats the correct way to do this?

Thanks.