year

Returns an integer that represents the year in the datepart of a specified date.

Syntax

year(date_expression)

date_expression – is an expression of type datetime, smalldatetime, date, time or a character string in a datetime format.

Example 1 – 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.