/SQL/Oracle sql select all days between two dates except weekends

Oracle sql select all days between two dates except weekends

-- 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');

Oracle sql all days except weekends

WHERE TO_CHAR(date_column, 'DY','NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN')

Source: stackoverflow.com

Similar codes

0 vote205 views1 answer
Sql injection payload list github
SQL
0 vote184 views2 answers
Pl sql auto increment
SQL
0 vote189 views2 answers
Mysql to python pandas
SQL
0 vote189 views1 answer
Java nosql sort
SQL
0 vote209 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote218 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 vote179 views1 answer
Default column value in sql same as other column
SQL
2 votes272 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote160 views1 answer
Mysql see column types
SQL
-1 vote205 views3 answers
Compute age mysql
SQL