Mega Code Archive

 
Categories / Oracle PLSQL Tutorial / SQL Data Types
 

Converting a Number Representation to DATE Format

SQL>  SELECT TO_DATE('031092','MMDDYY') "Birthday"  from DUAL; Birthday --------- 10-MAR-92 SQL>