Returns the quarter number of the year for the specified date.
- td_quarter_of_year Syntax
- td_quarter_of_year Argument Types
- Example: Querying for the Quarter Number of the Year
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 4, representing the quarter number from the beginning of the year, where 1 = first quarter (Jan/Feb/Mar) and 4 = fourth quarter (Oct/Nov/Dec).
See System Calendar View.