Apache Pinot Docs
Search…
latest
Configuration Reference
year
This section contains reference documentation for the year function.
Returns the year from the given epoch millis in UTC timezone.

Signature

year(tsInMillis)
year(tsInMillis, timeZoneId)

Usage Examples

1
select year(1609472186000) AS year
2
FROM ignoreMe
Copied!
year
2021
1
select year(1609472186000, 'America/Toronto') AS year
2
FROM ignoreMe
Copied!
year
2020
Last modified 6mo ago
Copy link