Built-in Functions → hour

hour() is a scalar date function that returns the hour component of a date/timestamp as an integer.

Signature

hour(field date)

The following table illustrates the *hour() parameter:

ParameterDescription
field datean expression evaluating to timestamp

Returns

int

Example

Extract the hour field from December 24, 2001 11:55:12.000.

hour(timestamp("2001-12-24 23:55:12.000"))

This example produces 23.