Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Register
Login
SQL Server Transact Basic to Expert - Display the Month integer value using systemdate
Karthikeyan Anbarasan
Jun 16, 2011
2.3
k
0
0
Blogs
WhatsApp
SQL Server Transact Basic to Expert - Display the Month integer value using systemdate
This blog shows how to do an get the Months integer value alone from the Systemdate in the output using SQL Query
Example:
SELECT DATEPART(m, GETDATE())
The expected result would be 2
SQL Server Transact Basic to Expert - Display the Month integer value using systemdate
Next Recommended Reading
SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query