Transact-SQL Reference
YEAR
Returns an integer that represents the year part of a specified date.
Syntax
YEAR ( date )
Arguments
date
An expression of type datetime or smalldatetime.
Return Types
int
Remarks
This function is equivalent to DATEPART(yy, date).
Examples
This example returns the number of the year from the date 03/12/1998.
SELECT "Year Number" = YEAR('03/12/1998')
GO
Here is the result set:
Year Number
------------
1998
This example specifies the date as a number. Notice that Microsoft® SQL Server™ database interprets 0 as January 1, 1900.
SELECT MONTH(0), DAY(0), YEAR(0)
Here is the result set:
----- ------ ------1 1 1900