/SQL/Sql calculate working days between two dates excluding weekends and holidays

Sql calculate working days between two dates excluding weekends and holidays

-- All dates between 01/07/2021 and 15/07/2021 excluding weekends
SELECT CAL_DATE
FROM (
         SELECT to_date('01/07/2021', 'DD/MM/YYYY') + ROWNUM - 1 AS CAL_DATE
         FROM ALL_OBJECTS
         WHERE ROWNUM <= to_date('15/07/2021', 'DD/MM/YYYY') 
                             - to_date('01/07/2021', 'DD/MM/YYYY') + 1)
WHERE to_char(CAL_DATE, 'DY', 'NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN');

Similar codes

12 votes171 views3 answers
Install sqlite driver ubuntu
SQL
0 vote169 views2 answers
Android sqlite tutorial for beginners
SQL
4 votes193 views2 answers
Mysql delete user if exists
SQL
1 vote194 views1 answer
Mysql query bulk insert
SQL
0 vote226 views1 answer
Sql server python connection
SQL
3 votes190 views3 answers
Mysql order by list
SQL
0 vote205 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
14 votes264 views1 answer
How to export db from mysql
SQL
11 votes206 views2 answers
Set default column value sql
SQL
2 votes200 views1 answer
Merge firstname and lastname in sql oracle
SQL