Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. LAST_DAY, TO_CHAR, TO_DATE
SQL>
SQL> SELECT TO_CHAR(LAST_DAY(TO_DATE('23SEP2006','ddMONyyyy')), 'Month dd, yyyy') FROM dual;
TO_CHAR(LAST_DAY(T
------------------
September 30, 2006
SQL>