Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Finding the last day of the month starting summer

SQL> SQL> SQL> -- Finding the last day of the month starting summer. SQL> SELECT TO_CHAR(LAST_DAY('30-JUN-97'),'MM/DD/YYYY HH:MM:SS AM') "Last_Day" from DUAL; Last_Day ---------------------- 06/30/1997 12:06:00 AM SQL> SQL>