Powered by GitBook

1 of 1

WEEKOFYEAR

Returns the week of year of the date or timestamp.

Syntax

WEEKOFYEAR(date_timestamp_expression string) → bigint

date_timestamp_expression: A DATE or TIMESTAMP expression.

Examples

WEEKOFYEAR example

SELECT WEEKOFYEAR('2003-02-01 11:43:22')
-- 5