timezoneHour

This section contains reference documentation for the timezoneHour function.

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

Signature

timezoneHour(timezoneId)

Usage Examples

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