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

Example 24.150. Simple example

Get current hour.

SQL> select hour (now ());
callret
INTEGER
_______________________________________________________________________________

21