SQL Function to Extract Year from Date

One of the most asked questions in forums and discussion board is how a SQL function to extract year from date. This can be done in multiple ways as shown below.

SELECT YEAR(GETDATE()) AS [Year]
GO
SELECT CONVERT(varchar(4), GETDATE(), 126) AS [Year]
GO
SELECT DATEPART(YEAR,GETDATE()) AS [Year]
GO
SELECT DATEPART(YEAR,GETDATE()) AS [Year]
GO
SELECT DATENAME(YEAR,GETDATE()) AS [Year]
GO
-- available from SQL Server 2012 
SELECT FORMAT(GETDATE(),'yyyy') AS [Year]

sql function to extract year from date

   

 

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

   

Leave a Reply

Your email address will not be published.