Apache Pinot Docs
latest
Search…
⌃K

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