week

Returns the week of the year in "date_expression" as an integer value in the range 1 to 53.

Syntax

week ( date_expression )

Example

week ( 11 November 2005 )

Result

Returns 45.