[RESOLVED] Get Month Name

[shakti5385]

Hi all
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

[salvelinus]

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.

[shakti5385]

ok thanks I got solution

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