Returns the year from the date indicated in the @date parameter. It is equivalent to the DATEPART function using the @datepart parameter with the year value.

Syntax

YEAR(@date)

Parameter

•@date: Date to parse