Relative time in SQL
It will depend on the database type and
the time format, but it will be something like this:
WHERE
Start_time 07:00:00 AND
Start_time < 08:00:00
Or depending on the database you could use:
WHERE
Start_time BETWEEN 07:00:00 AND 08:00:00
RBS
"Igor Sudnik" wrote in message
...
Hi, Guys. Could any one tell me how to write relative time expression in
query. I need something like: WHERE Start time is between "Today
07:00:00 -24H and Today 07:00:00". Any help is greatly appreciated.
|