sql Motnh() show name instead of number code example

Example: sql get month name

SELECT GETDATE() 'Today', FORMAT(GETDATE(),'MMMM') 'Month Name'