hour

This section contains reference documentation for the hour function.

Returns the hour of the day from the given epoch millis in UTC or specified timezone. The value ranges from 0 to 23.
Signature
hour(tsInMillis)
hour(tsInMillis, timeZoneId)
Usage Examples
select hour(1639351800000) AS hour
FROM ignoreMe
hour
23
select hour(1639351800000, 'CET') AS hour
FROM ignoreMe
hour
0

hour
23

hour
0

Histogram

isSubnetOf

Last modified 1yr ago