sql calculate working days between two dates excluding weekends and holidays

Solutions on MaxInterview for sql calculate working days between two dates excluding weekends and holidays by the best coders in the world

showing results for - "sql calculate working days between two dates excluding weekends and holidays"
Mathilda
17 Nov 2016
1-- All dates between 01/07/2021 and 15/07/2021 excluding weekends
2SELECT CAL_DATE
3FROM (
4         SELECT to_date('01/07/2021', 'DD/MM/YYYY') + ROWNUM - 1 AS CAL_DATE
5         FROM ALL_OBJECTS
6         WHERE ROWNUM <= to_date('15/07/2021', 'DD/MM/YYYY') 
7                             - to_date('01/07/2021', 'DD/MM/YYYY') + 1)
8WHERE to_char(CAL_DATE, 'DY', 'NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN');