Returns the number of weeks from the beginning of the calendar starting on 01/01/1900 to the specified date.
The td_week_of_calendar function provides improved performance compared to using the Sys_Calendar.Calendar system view to obtain similar results.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Result Type
The result is an INTEGER value representing the number of full weeks since and including the week of 01/01/1900, where the first partial week is 0.