Using TO_DATE within PL/SQL : Date Convert « PL SQL « Oracle PL / SQL






Using TO_DATE within PL/SQL

SQL>
SQL> -- Using TO_DATE within PL/SQL.
SQL> DECLARE
  2        v_Convert_Date DATE;
  3  BEGIN
  4        v_Convert_Date := TO_DATE('061167','MMDDYY');
  5        DBMS_OUTPUT.PUT_LINE('The converted date is: ' || v_Convert_Date);
  6  END;
  7  /
The converted date is: 11-JUN-67

PL/SQL procedure successfully completed.

SQL>


           
       








Related examples in the same category

1.Converting DATE to spelled-out character format