Apache Pinot Docs
latest
Search
⌃K

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