/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

7 votes242 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote285 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
19 votes274 views2 answers
Mysql tinyint max value
SQL
0 vote276 views1 answer
Suse status MySQL
SQL
2 votes245 views3 answers
Application.properties spring boot mysql
SQL
4 votes256 views2 answers
Select first and last row mysql
SQL
0 vote261 views1 answer
C# check if mysql query modified rows
SQL
0 vote240 views1 answer
What are the aggregate function in sql
SQL
2 votes284 views2 answers
How to run postgresql in linux
SQL
2 votes262 views2 answers
How to rename column name in sql server using query
SQL