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

hour
19

hour
0

hour
1

TIMECONVERT

timezoneMinute

Last modified 1yr ago