Adding one month to SYSDATE

SELECT TO_CHAR(SYSDATE, 'dd/mm/yyyy') Today,

TO_CHAR(ADD_MONTHS(SYSDATE, 1), 'dd/mm/yyyy') "minus1month",

TO_CHAR(ADD_MONTHS('20/11/2010', 1), 'dd/mm/yyyy') "minus1month_",

TO_CHAR(ADD_MONTHS(SYSDATE, -23), 'dd/mm/yyyy') "- 23 mon"

FROM dual;

SELECT TO_CHAR(ADD_MONTHS(TO_DATE('30/12/2010','dd/mm/yyyy'),1),'dd/mm/yyyy') "date_minus"

FROM dual;