sql pivot month code example

Example 1: sql get month name

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

Example 2: how to add month in update sql

UPDATE users
SET date = ADD_MONTHS(date, 1)