| Subject | Re: [ib-support] select records from within the last hour |
|---|---|
| Author | Martijn Tonies |
| Post date | 2002-07-25T13:26Z |
Ralf,
select extract(hour from current_time) from rdb$database
The EXTRACT functions let's you extract a value from a
date/time/datetime value.
You can also use MONTH, YEAR, DAY, MINUTE, SECOND
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
Upscene Productions
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."
> thanx for the amazing fast answer .-) works very well and fast ...HOUR can be used as this:
>
> When I donĀ“t have to use hour why is it an reserved word?
select extract(hour from current_time) from rdb$database
The EXTRACT functions let's you extract a value from a
date/time/datetime value.
You can also use MONTH, YEAR, DAY, MINUTE, SECOND
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
Upscene Productions
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."