Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>