//Assuming that the field name is Bdate
convert (varchar,(select DateName(month,dateadd(month,month(Bdate),0)-1)),103)
To Get MonthName from a Date Field from a table using Stored Procedure
August 1, 2009 at 11:57 am (sqlserver-2005)
Tags: date field, get month name, monthname, stored procedure
