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>