QuarterNumber_Of_Calendar Function | VantageCloud Lake - QuarterNumber_Of_Calendar - Teradata VantageCloud Lake

Returns the number of quarters from the beginning of the calendar to the specified date.

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

• QuarterNumber_Of_Calendar Syntax
• QuarterNumber_Of_Calendar Argument Types
• Example: Query the Number of Quarters from the Beginning of the Calendar

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 beginning of the calendar.

See System Calendar View.