Last updated 2 years ago
Was this helpful?
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)
week(tsInMillis)
week(tsInMillis, timeZoneId)
weekOfYear(tsInMillis)
weekOfYear(tsInMillis, timeZoneId)
select week(1639351800000) AS week FROM ignoreMe
49
select week(1639351800000, 'CET') AS week FROM ignoreMe
50
select weekOfYear(1639351800000) AS week FROM ignoreMe
select weekOfYear(1639351800000, 'CET') AS week FROM ignoreMe
This section contains reference documentation for the week function.