Skip to main content

TO_HOUR

Converts a date with time (timestamp/datetime) to a UInt8 number containing the number of the hour in 24-hour time (0-23). This function assumes that if clocks are moved ahead, it is by one hour and occurs at 2 a.m., and if clocks are moved back, it is by one hour and occurs at 3 a.m. (which is not always true – even in Moscow the clocks were twice changed at a different time).

Syntax​

to_hour( <expr> )

Arguments​

ArgumentsDescription
<expr>timestamp

Return Type​

UInt8 datatype.

Examples​

SELECT to_hour(now());
+----------------+
| to_hour(now()) |
+----------------+
|              6 |
+----------------+

SELECT to_hour(to_timestamp(1630812366));
+-----------------------------------+
| to_hour(to_timestamp(1630812366)) |
+-----------------------------------+
|                                 3 |
+-----------------------------------+