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
yow
is also supported.yearOfWeek(tsInMillis)yearOfWeek(tsInMillis, timeZoneId)
yow(tsInMillis)yow(tsInMillis, timeZoneId)
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 modified 1yr ago