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 updated