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

1
select quarter(1633046399000) AS quarter
2
FROM ignoreMe
Copied!
quarter
3
1
select quarter(1633046399000, 'UTC') AS quarter
2
FROM ignoreMe
Copied!
quarter
3
1
select quarter(1633046399000, 'CET') AS quarter
2
FROM ignoreMe
Copied!
quarter
4
Copy link