TO_DATE

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