Returns the number of weeks from the beginning of the year to the specified date.
The WeekNumber_Of_Year function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Result Type
The result is an INTEGER value from 0 through 53, where 1 is the first week of the year and 53 is the last week of the year. The value 0 means that there is a partial week in the year, Week0.
See System Calendar View for more information.