arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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 formatarrow-up-right.

hashtag
Signature

timezoneHour(timezoneId)

hashtag
Usage Examples

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

19

0

1

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