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