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');
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');