Finding the last day of the month starting summer : LAST_DAY « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. LAST_DAY

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>








Related examples in the same category

1.LAST_DAY: Get the last day of each month
2.Simple demo for LAST_DAY function
3.Calculating the Number of Days of Summer in June
4.select last_day( date'2000-02-01' ) "Leap Yr?"
5.select last_day( sysdate ) "Last day of this month"
6.LAST_DAY(hire_date)+1
7.LAST_DAY(x): get the date of the last day of the month that contains x.