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