SQL Server Transact Basic to Expert - Display the Month integer value using systemdateKarthikeyan Anbarasan15yPublished Jun 16, 2011, 12:00 AMUpdated Jun 16, 2011, 9:14 AM3.8k00Reactions×25Blog This blog shows how to do an get the Months integer value alone from the Systemdate in the output using SQL QueryExample:SELECT DATEPART(m, GETDATE())The expected result would be 2CommentsJoin 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.