week
This section contains reference documentation for the week function.
Returns the ISO week of the year from the given epoch millis in UTC or specified timezone. The value ranges from 1 to 53.
week(tsInMillis)week(tsInMillis, timeZoneId)weekOfYear(tsInMillis)weekOfYear(tsInMillis, timeZoneId)
select week(1639351800000) AS week
FROM ignoreMe
week |
---|
49 |
select week(1639351800000, 'CET') AS week
FROM ignoreMe
week |
---|
50 |
select weekOfYear(1639351800000) AS week
FROM ignoreMe
week |
---|
49 |
select weekOfYear(1639351800000, 'CET') AS week
FROM ignoreMe
week |
---|
50 |
Last modified 1yr ago