Add Negative time : ADD_MONTHS « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. ADD_MONTHS
SQL>
SQL>
SQL> SELECT TO_CHAR(TO_CHAR(ADD_MONTHS(SYSDATE, -23), 'ddMONyyyy')) "- 23 mon"
  2  FROM dual;

- 23 mon
---------
29JUN2005

SQL>
SQL>








13.2.ADD_MONTHS
13.2.1.ADD_MONTHS(x, y) gets the result of adding y months to x.
13.2.2.Subtract 13 months from the January 1, 2005
13.2.3.Combine ADD_MONTHS() function with To_Date
13.2.4.Combine ADD_MONTHS() with TO_CHAR() and TO_DATE
13.2.5.SELECT ADD_MONTHS('28-NOV-05', 1) FROM DUAL;
13.2.6.SELECT ADD_MONTHS('29-NOV-05', 1) FROM DUAL;
13.2.7.SELECT ADD_MONTHS('30-NOV-05', 1) FROM DUAL;
13.2.8.SELECT ADD_MONTHS('31-DEC-05', -1) FROM DUAL;
13.2.9.SELECT ADD_MONTHS('01-JAN-2005', 3) FROM dual;
13.2.10.SELECT ADD_MONTHS('01-JAN-2005', -3) FROM dual; (2)
13.2.11.Add Negative time