arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

year

This section contains reference documentation for the year function.

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

hashtag
Signature

year(tsInMillis)

year(tsInMillis, timeZoneId)

hashtag
Usage Examples

year
year
select year(1609472186000) AS year
FROM ignoreMe

2021

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

2020