[RESOLVED] Get Month Name

Hi all :wave:
Is there any best way to get month name in SQL SERVER 2005.
I know that we can do this using our own function, but just i want to conform that if SQL SERVER provide any function for month name if we have month number i.e. 1,2..12

Thanks

Don't know if this works in SQL Server, but Access has a MonthName function.
MonthName(2) returns February, MonthName (2, 1) returns Feb
I'd guess SQL Server would have something similar.

ok thanks I got solution

Code:

---

SELECT DATENAME(MONTH,'1900/' + CAST(2 AS VARCHAR(2)) + '/01')

---