EXTRACTWEEK

This function returns the week part of the input timestamp value. Also see EXTRACT.

Syntax

SELECT EXTRACT(WEEK FROM TIMESTAMP timestamp_expr);