At 02:17 PM 25-07-02 +0200, you wrote:

>Hi everbody
>
>I have a very big table and want to fetch only the records from within
>the last hour. I tried something like the following
>
>select * from aTable
>where TStamp >= ('TODAY' - 1 hour)

The unit for computation on date/time types is 1 day. So...

select * from aTable
where TStamp >= current_timestamp - (1.0000000/24)

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________