Oracle PL/SQL Tutorial/PL SQL Data Types/Convert to Date

Use TO_DATE to assign value to DATE type variable

   <source lang="sql">

SQL> SQL> SET ECHO ON SQL> SET SERVEROUTPUT ON SQL> DECLARE

 2    age   DATE;
 3
 4  BEGIN
 5    age := TO_DATE ("12-1-2000","mm-dd-yyyy");
 6    DBMS_OUTPUT.PUT_LINE("age:");
 7    DBMS_OUTPUT.PUT_LINE(age);
 8  END;
 9  /

age: 01-DEC-00 PL/SQL procedure successfully completed. SQL></source>