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

month

This section contains reference documentation for the month function.
Returns the month of the year from the given epoch millis in UTC or specified timezone. The value ranges from 1 to 12.

Signature

month(tsInMillis)
month(tsInMillis, timeZoneId)

Usage Examples

select month(1633046399000, 'UTC') AS month
FROM ignoreMe
month
9
select month(1633046399000, 'CET') AS month
FROM ignoreMe
month
10
Last modified 1yr ago