SQL> SELECT TO_CHAR(LAST_DAY('30-JUN-99'),'MM/DD/YYYY HH:MM:SS AM') "Last_Day" 2 from DUAL;Last_Day----------------------06/30/1999 12:06:00 AMSQL>