year in sql code example Example 1: get current year sql select year(getdate()) Example 2: year sql server function YEAR(input_date)