select last_day(sysdate) as lastday from dual;
lastday ------------------- 2006/04/30 09:00:00
select last_day('2006/02/01') as lastday from dual;
lastday ---------- 2006/02/28