Apache Pinot Docs
latest
Ask or search…
K
Comment on page

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

select hour(1639351800000) AS hour
FROM ignoreMe
hour
23
select hour(1639351800000, 'CET') AS hour
FROM ignoreMe
hour
0
Last modified 1yr ago