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

year
2021

year
2020

week

yearOfWeek

Last modified 1yr ago