Oracle PL/SQL Tutorial :LAST_DAY, TO_CHAR, TO_DATE

Oracle PL/SQL Tutorial :LAST_DAY, TO_CHAR, TO_DATE

SQL>

SQL> SELECT TO_CHAR(LAST_DAY(TO_DATE('01APR2011','ddMONyyyy')), 
 'Month dd, yyyy') FROM dual;

TO_CHAR(LAST_DAY(T
------------------
  April 01, 2011

SQL>
SQL>