/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

0 vote129 views1 answer
Get role postgres
SQL
0 vote120 views1 answer
Authentication in sql server
SQL
0 vote130 views1 answer
Oracle session statistics
SQL
2 votes118 views2 answers
Spring import sql
SQL
-1 vote142 views1 answer
How to Activate the database
SQL
1 vote129 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
24 votes130 views6 answers
Replace mysql
SQL
15 votes254 views2 answers
Sql order by alphabetical
SQL
3 votes85 views4 answers
Mysql delete duplicate rows
SQL
1 vote146 views2 answers
Mysql extract number from string
SQL