get month name and year from date in sql in table code example Example: sql get month name SELECT GETDATE() 'Today', FORMAT(GETDATE(),'MMMM') 'Month Name'