Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. TO_DATE function to convert from characters to dates explicitly
SQL>
SQL> SELECT TO_CHAR(LAST_DAY(TO_DATE('23SEP2006','ddMONyyyy'))) FROM dual;
TO_CHAR(L
---------
30-SEP-06
SQL>