Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Performing Calculations on a Converted Date

SQL> SQL> set serveroutput on SQL> set echo on SQL> SQL> DECLARE   2       v_Convert_Date DATE;   3  BEGIN   4       v_Convert_Date := TO_DATE('042199','MMDDYY') + 5;   5       DBMS_OUTPUT.PUT_LINE('The converted date is: ' || v_Convert_Date);   6  END;   7  / The converted date is: 26-APR-99 PL/SQL procedure successfully completed.