Returns the number of months from the beginning of the quarter to the specified date.
The td_month_of_quarter function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.
- td_month_of_quarter Syntax
- td_month_of_quarter Argument Types
- Example: Querying for the Number of Months from the Beginning of the Quarter
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 3.
See System Calendar View for more information.