Built-in Functions → hour

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

Signature

Copy
hour(field date)

The following table illustrates the *hour() parameter: | Parameter | Description | |-|-| | field date | an expression evaluating to timestamp |

Returns

int

Example

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

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

This example produces 23.