oracle sql select all days between two dates except weekends

Solutions on MaxInterview for oracle sql select all days between two dates except weekends by the best coders in the world

Search
showing results for - "oracle sql select all days between two dates except weekends"
Alessia
09 May 2019
1-- All dates between 01/07/2021 and 15/07/2021 excluding weekends
2SELECT CAL_DATE
3FROM (
4         SELECT to_date('01/07/2021', 'DD/MM/YYYY') + ROWNUM - 1 AS CAL_DATE
5         FROM ALL_OBJECTS
6         WHERE ROWNUM <= to_date('15/07/2021', 'DD/MM/YYYY') 
7                             - to_date('01/07/2021', 'DD/MM/YYYY') + 1)
8WHERE to_char(CAL_DATE, 'DY', 'NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN');
source
Tomas
23 Aug 2017
1WHERE TO_CHAR(date_column, 'DY','NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN')
similar questions
sql date between one weekoracle generate list of dates in between a date rangesql list dates between two datesoracle current date plus 1 monthoracle list days between two datesoracle select row max dateoracle difference between two dates in secondsoracle sql generate list of daysoracle sql first day of monthhow to get all dates in a month in oraclesql get latest of 2 datetimesoracle sql first day of quarteroracle current date without timeoracle sql day of month from dateoracle difference between two dates in yearssql get number of days between two datesoracle sql first day of yearoracle search in date columnsoracle current date minus 1 daydiff c3 a9rence entre deux dates sql oracleoracle all dates between two datesselect the date 30 days less that the todays date sql requestoracle duration between timestamps
queries leading to this page
how to calculate number of days between two dates excluding weekends in oraclesql calculate working days between two dates excluding weekends and holidaysquery to find number of days between two dates in oraclehow to calculate number of days between two dates in oracleoracle sql select all days between two dates except weekendsreturn number of days between two dates in oracle sqloracle sql all days except weekendsoracle list dates without weekendsoracle sql select all days between two dates except weekends