Calculating the Number of Days of Summer in June

  
SQL> SELECT LAST_DAY('20-JUN-99') "Last_Day",
  2            LAST_DAY('20-JUN-99') - TO_DATE('20-JUN-99') "Days_Summer"
  3       from DUAL;
Last_Day             Days_Summer
-------------------- -----------
30-JUN-0099 00:00:00          10

1 row selected.

SQL>
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.	Finding the last day of the month starting summer
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.

Calculating the Number of Days of Summer in June : LAST_DAY « Date Timezone « Oracle PL / SQL

Related examples in the same category