Converting number representation to DATE format
SQL> SQL> -- Converting number representation to DATE format. SQL> SELECT TO_DATE('061167','MMDDYY') "Birthday" from DUAL; Birthday --------- 11-JUN-67 SQL>