how to specifiy year in year function sql code example
Example 1: print year of a date sql
SELECT EXTRACT(YEAR FROM CURRENT_DATE)
Example 2: year sql server function
YEAR(input_date)
SELECT EXTRACT(YEAR FROM CURRENT_DATE)
YEAR(input_date)