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