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