SQL Server - Convert Month Number to Month Name

Here’s a simple way to convert a month number to month name in SQL Server

DECLARE @monthNum int;
SET     @monthNum = 7;
SELECT  DateName( month , DateAdd( month , @MonthNum - 1 , '1900-01-01' ))
        as 'MonthName'
        WHERE @monthNum between 1 and 12

OUTPUT



In order to get the MonthName of the current date, just use

SELECT DATENAME(month, GETDATE()) AS 'MonthName'

OUTPUT