Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. 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-99          10
SQL>