Example: Querying the Number of Months from the Quarter Beginning - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

If the current date is April 20, 2011, the following query returns 1 because April 20, 2011, is in the first month of the quarter in the Teradata calendar:

SELECT TD_SYSFNLIB.MONTHNUMBER_OF_QUARTER(CURRENT_DATE);

The following query returns 1 because April 20, 2011, is in the first month of the quarter in the ISO calendar:

SELECT TD_SYSFNLIB.MONTHNUMBER_OF_QUARTER(DATE '2011-04-20', 'ISO');