Adding One Month : SYSDATE « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. SYSDATE
SQL> SELECT ADD_MONTHS(TO_DATE('31-MAR-99'),1) from DUAL;

ADD_MONTH
---------
30-APR-99

SQL>
SQL>








13.17.SYSDATE
13.17.1.SYSDATE() returns the current datetime set in the operating system
13.17.2.last_day(sysdate)
13.17.3.Default Output of SYSDATE
13.17.4.Combining TO_CHAR to Format SYSDATE
13.17.5.Removing the Time from SYSDATE
13.17.6.Truncating to the Quarter
13.17.7.Adding Two Months to SYSDATE
13.17.8.Adding One Month
13.17.9.Finding the First Monday After the Current Date and Time