The Oracle and PL/SQL TO_DATE function converts a string to a date
The general format is:
TO_DATE(char [,fmt])
Example 1:
SELECT TO_DATE('15/06/2015','DD/MM/YYYY') FROM DUAL;
returns:
15-JUN-15
Example 2:
SELECT TO_DATE('061515','MMDDAA') FROM DUAL;
returns:
15-JUN-15