/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 vote126 views1 answer
Postgresql stored procedure update table values
SQL
0 vote133 views1 answer
Oracle select partition
SQL
1 vote157 views1 answer
Insert column after column mysql
SQL
11 votes308 views4 answers
Round in sql
SQL
6 votes166 views3 answers
Mysql change auto_increment start value
SQL
0 vote126 views2 answers
Default constraint in ms sql
SQL
0 vote150 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote125 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
-1 vote85 views1 answer
Oracle db list usernames
SQL
0 vote125 views1 answer
Adding primery key constraint to a column
SQL