Apache Pinot Docs
latest
Search
⌃K

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

select year(1609472186000) AS year
FROM ignoreMe
year
2021
select year(1609472186000, 'America/Toronto') AS year
FROM ignoreMe
year
2020
Last modified 1yr ago