Apache Pinot Docs
Search…
latest
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
Last modified 1mo ago
Copy link