Want to get monthname from a date

[wavecruzin]

I am using SQL Server and want to extract the month name (e.g. January, February, March etc) from a date. I am going to be plotting the data in a chart and need the data in month order not alphabetical order. It doesn't look like the
datepart() function will do this. Can the SQL date function be used in SQL Server? I'm trying to avoid having the x axis of my graph have values like:
1, 2, 3, 4, 5, etc for the months and would prefer the month names instead (expressed in their correct month order).

[MrByte]

How about using

DATENAME(month, '5/1/06')

It will return the Month Name, May in the above sample

I am using SQL Server and want to extract the month name (e.g. January, February, March etc) from a date. I am going to be plotting the data in a chart and need the data in month order not alphabetical order. It doesn't look like the
datepart() function will do this. Can the SQL date function be used in SQL Server? I'm trying to avoid having the x axis of my graph have values like:
1, 2, 3, 4, 5, etc for the months and would prefer the month names instead (expressed in their correct month order).

[yanto]

Thanks to MrByte

I try your solution and its running well
see my script test http://sqltosql.blogspot.com/2012/08...onth-name.html