Hi Helen ...

thanx for the amazing fast answer .-) works very well and fast ...

When I don´t have to use hour why is it an reserved word?
And why I have to use many zeros? For casting reasons I guess? But therefore
one is enough, isn´ it? And It works as well without any zero?!?

best reagrds and thanx again

Ralf Grenzing



Helen Borrie schrieb:

> 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/
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/