Example: Querying for the Year of the Specified Date - Advanced SQL Engine - Teradata Database

If the current date is November 14, 1977, the following queries return the value 1977 as the result, which is the year of the specified date.

SELECT td_year_of_calendar(CURRENT_DATE);
SELECT td_year_of_calendar(DATE '1977-11-14');