| Subject | select records from within the last hour |
|---|---|
| Author | Ralf Grenzing |
| Post date | 2002-07-25T12:17:18Z |
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)
But it doesn´t work. But I know *hour* is a reserved word, so how can I
use it?
in hope
Ralf Grenzing
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)
But it doesn´t work. But I know *hour* is a reserved word, so how can I
use it?
in hope
Ralf Grenzing