Performing Calculations on a Converted Date : Date Calculation « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Date Calculation

Performing Calculations on a Converted Date

 
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-2099 00:00:00

PL/SQL procedure successfully completed.

SQL>
SQL> --

 

Related examples in the same category