Apache Pinot Docs
Search…
latest
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

1
SELECT timezoneHour('America/Toronto') AS hour
2
FROM ignoreMe
Copied!
hour
19
1
SELECT timezoneHour('UTC') AS hour
2
FROM ignoreMe
Copied!
hour
0
1
SELECT timezoneHour('Europe/Rome') AS hour
2
FROM ignoreMe
Copied!
hour
1
Last modified 1mo ago
Copy link