DayOccurrence_Of_Month Function | VantageCloud Lake - DayOccurrence_Of_Month - Teradata VantageCloud Lake

Returns the nth occurrence of the weekday in the month for the specified date.

The DayOccurrence_of_Month function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.

• DayOccurrence_Of_Month Syntax
• DayOccurrence_Of_Month Argument Types
• Example: Querying the nth Occurrence of the Weekday in the Month

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Result Type

The result is an INTEGER value between 1 and 5, representing the n th occurrence of the weekday in the month.

See System Calendar View.