Subject Re: [ib-support] select records from within the last hour
Author Helen Borrie
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)


All for Open and Open for All
Firebird Open SQL Database · ·