get year sqlserver 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)