/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

2 votes170 views2 answers
How to check database username and password in postgresql
SQL
0 vote220 views1 answer
How to open mysql in docker
SQL
0 vote143 views1 answer
Copy data from cell to cell mysql
SQL
4 votes134 views1 answer
And or sql order of operations
SQL
0 vote200 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote271 views1 answer
Get last inserted primary key
SQL
0 vote141 views2 answers
Jupyter notebook connect to database
SQL
0 vote135 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote213 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote179 views1 answer
Resullt all update knex mysql
SQL