also 1 stands for a day, so:

where MyTimestamp > AnotherTimestamp-1

means where MyTimeStamp > 24 hours before "AnotherTimestamp"




--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 10:37 PM 22/11/2004 +0000, you wrote:
>
>
> >I have a field that records the date + time, ¿How can I compare if
> >Date +time > "x" in a query?
>
> where MyTimestamp > AnotherTimestamp
>
> where MyTimestamp > '25.12.2003' (date or timestamp literal, in an
> accepted format)
>
> where MyTimestamp > MyTimestamp -10
>
> where MyTimestamp > CURRENT_DATE - 30
>
> where MyTimestamp > CURRENT_TIMESTAMP - 1
>
> and so on...
>
> ./hb