/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

4 votes217 views2 answers
Sql offset
SQL
3 votes242 views4 answers
Psql list tables in schema
SQL
8 votes157 views2 answers
Alter column name in mssql
SQL
4 votes198 views2 answers
Tsql utf to local time
SQL
1 vote233 views1 answer
Moodle query first user access
SQL
1 vote196 views2 answers
Mysql allow remote connections
SQL
0 vote754 views1 answer
Sql show table name in result
SQL
0 vote204 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote295 views1 answer
Mysql select random rows large table
SQL
1 vote295 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL