Adding One Month a certain date : SYSDATE « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. SYSDATE

Adding One Month a certain date

 
SQL>
SQL> Select ADD_MONTHS(TO_DATE('31-MAR-99'),1) from DUAL;
ADD_MONTHS(TO_DATE('
--------------------
30-APR-0099 00:00:00

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.select sysdate
2.Using the SYSDATE function: return the current date from the system
3.Get current operating system date
4.Combining TO_CHAR to Format SYSDATE
5.Removing the Time from SYSDATE
6.Truncating to the Quarter
7.Adding Two Months to SYSDATE
8.Finding the First Monday After the Current Date and Time
9.use sysdate to init a variable
10.Minus days from sysdate