Apache Pinot Docs
latest
Search
⌃K

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