WEEK_ISO

The WEEK_ISO function returns an integer between 1 and 53 that represents the week of the year.

Syntax

WEEK_ISO(expression)

Example

SELECT WEEK_ISO(date '2011-1-2')