YEAR Function in SQL Server

YEAR()

This is used to get the Year number from the  date time object.

Example:
SELECT YEAR(getdate()) AS 'Year'
 

Output :
Year
2012

Back