Returns the number of quarters from the beginning of the calendar starting on 01/01/1900 to the specified date.
The td_quarter_of_calendar function provides improved performance compared to using the Sys_Calendar.Calendar system view to get similar results.
- td_quarter_of_calendar Syntax
- td_quarter_of_calendar Argument Types
- Example: Querying for the Number of Quarters from the Beginning of the Calendar
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 representing the number of quarters since and including the first quarter of 1900.
See System Calendar View.