1 of 1

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)

select year(1609472186000) AS year
FROM ignoreMe

year

select year(1609472186000, 'America/Toronto') AS year
FROM ignoreMe

year

This section contains reference documentation for the year function.

Returns the year from the given epoch millis in UTC timezone.

year(tsInMillis)
year(tsInMillis, timeZoneId)

select year(1609472186000) AS year
FROM ignoreMe

year

select year(1609472186000, 'America/Toronto') AS year
FROM ignoreMe

year