sql server display MONTH(date) as string of that month code example Example: sql get month name SELECT GETDATE() 'Today', FORMAT(GETDATE(),'MMMM') 'Month Name'