Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

TO_DATE() converts the strings 04-JUL-2006 to the date July 4, 2006

SQL> SQL> SELECT TO_DATE('04-JUL-2006'), TO_DATE('04-JUL-06') FROM dual; TO_DATE(' TO_DATE(' --------- --------- 04-JUL-06 04-JUL-06 SQL>