Shouldn't that

(CHECKIN_TIMESTAMP <= :CHECKIN_TIMESTAMP)

be

(CHECKIN_TIMESTAMP >= :CHECKIN_TIMESTAMP)

instead?


Best Regards

Stefan

> 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.







> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !

> Also search the knowledgebases at http://www.ibphoenix.com

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links



>

--
Stefan Heymann
www.destructor.de/firebird