yearOfWeek

This section contains reference documentation for the yearOfWeek function.

Returns the year of the ISO week from the given epoch millis and timezone id. Alias yowis also supported.

Signature

yearOfWeek(tsInMillis)

yearOfWeek(tsInMillis, timeZoneId)

yow(tsInMillis)

yow(tsInMillis, timeZoneId)

Usage Examples

select yearOfWeek(1609731386000) AS year
FROM ignoreMe
year

2021

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

2020

select yow(1609731386000) AS year
FROM ignoreMe
year

2021

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

2020

Last updated