Returns an integer that represents the year in the datepart of a specified date.
year(date_expression)
is an expression of type datetime, smalldatetime, date, time or a character string in a datetime format.
Returns the integer 03:
year("11/02/03") ---------- 03 (1 row(s) affected)
year(date_expression) is equivalent to datepart(yy, date_expression).
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute year.