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

1
select month(1633046399000, 'UTC') AS month
2
FROM ignoreMe
Copied!
month
9
1
select month(1633046399000, 'CET') AS month
2
FROM ignoreMe
Copied!
month
10
Last modified 6mo ago
Copy link