select last_day( sysdate ) "Last day of this month"
SQL> SQL> select last_day( sysdate ) "Last day of this month" 2 from dual; Last day --------- 30-JUN-08 1 row selected. SQL> SQL> --