dateadd t sql code example
Example 1: how to add month in update sql
UPDATE users
SET date = DATEADD(MONTH, 1, date)Example 2: insert date sql
INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));UPDATE users
SET date = DATEADD(MONTH, 1, date)INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));