Convert Month Number to Month Name Function in SQL

 Admin   
234 View    Jan 10 2020 6:33PM

Convert Month Number to Month Name Function in SQL

You can Try this one 

SELECT DATENAME(month, DATEADD(month, @mydate-1, CAST('2008-01-01' AS datetime)))

 

 

Thank You For Visit web.