SQL SERVER MONTH FORMULA

SQL SERVER MONTH FORMULA

THEORY:

SELECT MONTH([DATE COLUMN]) AS [COLUMN ALIAS NAME]

-- EXAMPLE

SELECT MONTH(GETDATE()) AS [DISPLAY THE MONTH NUMBER OF THE CURRENT DATE AND TIME];