Adding Two Months to SYSDATE : SYSDATE « Date Timezone « Oracle PL / SQL






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

Adding Two Months to SYSDATE

 
SQL>
SQL> SELECT ADD_MONTHS(SYSDATE,2) from DUAL;
ADD_MONTHS(SYSDATE,2
--------------------
16-AUG-2008 18:08:07

1 row selected.


SQL>
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 One Month a certain date
8.Finding the First Monday After the Current Date and Time
9.use sysdate to init a variable
10.Minus days from sysdate