Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Finding the Last Day of the Month Starting Summer

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>