description
This section contains reference documentation for the timezoneHour function.

timezoneHour

Returns the hour of the time zone offset. The timezoneId provided should be in Joda Time format.

Signature

timezoneHour(timezoneId)

SELECT timezoneHour('America/Toronto') AS hour
FROM ignoreMe

hour
19

SELECT timezoneHour('UTC') AS hour
FROM ignoreMe

hour
0

SELECT timezoneHour('Europe/Rome') AS hour
FROM ignoreMe

hour
1