1 of 1

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)

select hour(1639351800000) AS hour
FROM ignoreMe

hour

select hour(1639351800000, 'CET') AS hour
FROM ignoreMe

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.

hour(tsInMillis)
hour(tsInMillis, timeZoneId)

select hour(1639351800000) AS hour
FROM ignoreMe

hour

select hour(1639351800000, 'CET') AS hour
FROM ignoreMe

hour