Name
hour — get hour from a datetime
Synopsis
hour
( |
in dt datetime ); |
Description
hour takes a datetime and returns an integer containing a number representing the hour of
the datetime.
Parameters
dt
A datetime .
Return Values
An INTEGER containing the hour.
Examples
Example24.150.Simple example
Get current hour.
SQL> select hour (now ()); callret INTEGER _______________________________________________________________________________ 21