Returns an integer that represents the year of the specified date.
For an overview of all Transact-SQL date and time data types and functions, see Date and Time Data Types and Functions (Transact-SQL). For information and examples that are common to date and time data types and functions, see Using Date and Time Data.
YEAR returns the same value as DATEPART (year, date).
If date only contains a time part, the return value is 1900, the base year.