Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Adding two months to current date
SQL>
SQL>
SQL> -- Adding two months to SYSDATE.
SQL>  SELECT ADD_MONTHS(SYSDATE,2) from DUAL;
ADD_MONTH
---------
31-OCT-06