Convert Month Number to Month Name Function in SQL

Declare @MonthNumber int
SET @MonthNumber=DatePart(Month,GETDATE())
Select DateName( month , DateAdd( month , @MonthNumber , 0 ) - 1 )

Explaination:

1. First Decalre Variable `MonthNumber`
2. Get Current Month for `DatePart` which Return Month Number
3. Third Query Return Month Name

i think this is enough to get month name when u have date.

SELECT DATENAME(month ,GETDATE())

to_char(to_date(V_MONTH_NUM,'MM'),'MONTH')

where `V_MONTH_NUM` is the month number

SELECT to_char(to_date(V_MONTH_NUM,'MM'),'MONTH') from dual;

select monthname(curdate());

OR

select monthname('2013-12-12');

Working for me

SELECT MONTHNAME(<fieldname>) AS "Month Name" FROM <tablename> WHERE <condition>

**Use this statement to convert Month numeric value to Month name.**

SELECT CONVERT(CHAR(3), DATENAME(MONTH, GETDATE()))

Use this statement for getting month name:

DECLARE @date datetime
SET @date='2015/1/4 00:00:00'

SELECT CAST(DATENAME(month,@date ) AS CHAR(3))AS 'Month Name'

This will give you short month name. Like this: Jan, Feb, Mar, etc.

Here is my solution using some information from others to solve a problem.

datename(month,dateadd(month,datepart(month,Help_HelpMain.Ticket_Closed_Date),-1)) as monthname

**Use the Best way**

Select DateName( month , DateAdd( month , @MonthNumber , -1 ))

Just subtract the current month from today's date, then add back your month number. Then use the datename function to give the full name all in 1 line.

print datename(month,dateadd(month,-month(getdate()) + 9,getdate()))