MSSQL – Get month name from date Vis Dotnet 2 years ago Select DateName(MONTH, GetDate()) as ‘month name’