Powered by GitBook

1 of 1

Loading...

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

year

year

year

year

2021

2020

select yow(1609731386000) AS year
FROM ignoreMe

2021

2020

select yearOfWeek(1609731386000) AS year
FROM ignoreMe

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

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