habeebmatrix
8/9/2017 - 11:08 AM

SQL - Convert Month Number to Month Name

SQL - Convert Month Number to Month Name

SQL - Convert Month Number to Month Name.sql
content_copyfile_download
Select DateName( month , DateAdd( month , @MonthNumber , 0 ) - 1 )

-- Alternate

Select DateName( month , DateAdd( month , @MonthNumber , -1 ) )