Apache Pinot Docs
Search…
latest
Configuration Reference
hour
This section contains reference documentation for the hour function.
Returns the hour of the day from the given epoch millis in UTC or specified timezone. The value ranges from 0 to 23.

Signature

hour(tsInMillis)
hour(tsInMillis, timeZoneId)

Usage Examples

1
select hour(1639351800000) AS hour
2
FROM ignoreMe
Copied!
hour
23
1
select hour(1639351800000, 'CET') AS hour
2
FROM ignoreMe
Copied!
hour
0
Last modified 6mo ago
Copy link