Month Function in SQL Server

MONTH()

This is used to get the month number from the date.

Example:
SELECT MONTH(getdate()) AS 'Month'
 

Output :
Month
7

Back