Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
WEEK_ISO
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')