Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. 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>