Post
Ask Question

SQL Server Transact Basic to Expert - Display the Year alone using systemdate

This blog shows how to do an get the year alone from the Systemdate in the output using SQL Query

Example:

SELECT DATEPART(yy, GETDATE())

The expected result would be 2011
Next Recommended Reading SQL Server Transact Basic to Expert - Display Current date in mm/dd/yyyy format