WEEK_IN_YEAR

Returns a number representing the calendar week of a "date_expression". The first week is from January 1 through January 7

Syntax

WEEK_IN_YEAR ( date_expression )

Example

WEEK_IN_YEAR ( '2012-02-29' )

Result

9

Parent topic: Date Functions