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

quarter

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

Signature

quarter(tsInMillis)
quarter(tsInMillis, timeZoneId)

Usage Examples

select quarter(1633046399000) AS quarter
FROM ignoreMe
quarter
3
select quarter(1633046399000, 'UTC') AS quarter
FROM ignoreMe
quarter
3
select quarter(1633046399000, 'CET') AS quarter
FROM ignoreMe
quarter
4