Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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