Date Timestamp Functions Oracle PLSQL Tutorial

SQL>
SQL> SELECT TO_CHAR(LAST_DAY('23SEP2006'))FROM dual;
TO_CHAR(L
---------
30-SEP-06
SQL>