Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. 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>