Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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>