Functions/Dates & time/weekofyear
Dates & time Scalar

weekofyear()

Extract the weekofyear component from a date or timestamp

Arguments & returns

4 overloads

weekofyear(ts)

Scalar
Overload link ts Returns
#01 DATE BIGINT
#02 INTERVAL BIGINT
#03 TIMESTAMP BIGINT
#04 TIMESTAMP WITH TIME ZONE BIGINT

Example

weekofyear example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Prestoweek_of_year()

WEEK_OF_YEAR(timestamp '2012-08-08 01:00:00')
In DuckDB
WEEKOFYEAR(CAST('2012-08-08 01:00:00' AS TIMESTAMP))

SQLGlot example ↗

Snowflakeweekiso()

SELECT WEEKISO('2024-01-15'::DATE)
In DuckDB
SELECT WEEKOFYEAR(CAST('2024-01-15' AS DATE))

SQLGlot example ↗