Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

SELECT TO_DATE(7 4 06, MM DD YY)

SQL>  SELECT TO_DATE('7.4.06', 'MM.DD.YY')   2  FROM dual; TO_DATE(' --------- 04-JUL-06 SQL>