YEAR
Returns an integer that represents the year of the specified date.
Syntax
YEAR ( date )
Arguments
date
Is an expression that can be resolved to a time, date, smalldatetime, datetime, datetime2, or datetimeoffset value. The date argument can be an expression, column expression, user-defined variable, or string literal.
Return types
int
Example
SELECT YEAR(0) as [TheBeginning];