To convert the numeric month into alphabetic

Question

How To convert the numeric month into alphabetic

Niradhip Chakraborty · Answer

Try this: string strMonth = DateTime.Now.ToString(MMMM); or if you want to use current culture to get the month name use the following code. use 'using System.Globalization;' namespace. string monthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(DateTime.Now.Month); or You have to use switch statement and get the month in alphabet. If you want to do it in sqlserver Try this: Select DateName ( month  DateAdd ( month  @MonthNumber  0 ) - 1 )