week

Returns the week of the year in "date_expression" as an integer value (1-53), where 1 represents the first week of the year.

Syntax

week ( date_expression )