SQL>SQL>SQL> --The LAST_DAY function returns the last day of any monthSQL>SQL> SELECT TO_CHAR(LAST_DAY('23SEP2006')) FROM dual;TO_CHAR(L---------30-SEP-06SQL>SQL>