Date Timestamp Functions Oracle PLSQL Tutorial

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 AM
SQL>