SQL Server Transact Basic to Expert - Display the Year alone using systemdateKarthikeyan Anbarasan15yPublished Jun 16, 2011, 12:00 AMUpdated Jun 16, 2011, 9:03 AM3.5k00Reactions×25Blog This blog shows how to do an get the year alone from the Systemdate in the output using SQL QueryExample:SELECT DATEPART(yy, GETDATE())The expected result would be 2011CommentsJoin the conversation! Your thoughts help the community grow.Sign in to leave a commentIt is the same account you read, post and publish with — and you will come straight back to this page.Sign inCreate an account
Join the conversation! Your thoughts help the community grow.