SQL Server Transact Basic to Expert - Display the Month integer value using systemdate

Karthikeyan Anbarasan
13y
3.5k
0
0

Blog

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

Up Next

SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query

Ebook Download

View all

Basics of SQL Server

Read by 1.5k people

Download Now!

Learn

View all