Comment on page

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