Returns the nth occurrence of the weekday in the month for the specified date.
The td_weekday_of_month function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.
- td_weekday_of_month Syntax
- td_weekday_of_month Argument Types
- Example: Querying for the nth Occurrence of the Weekday in the Month
See also "Function Name Overloading" in Using Functions with CREATE/REPLACE FUNCTION (SQL Form).
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Result Type
The result is an INTEGER value from 1 to 5, representing the n th occurrence of the weekday in the month.