Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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> --