/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 votes184 views1 answer
Show line number in sql server
SQL
3 votes141 views1 answer
DB: in eloquent using sql
SQL
3 votes156 views1 answer
Delete all content in table mysql
SQL
0 vote149 views1 answer
Power bi union columns
SQL
14 votes148 views2 answers
Sql cast
SQL
6 votes172 views1 answer
To count number of rows in SQL table
SQL
0 vote141 views1 answer
How to use query in nosql
SQL
0 vote141 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote168 views1 answer
Autocommit mysql
SQL
0 vote171 views1 answer
Oracle winter time change
SQL