sql calculate working days between two dates excluding weekends and holidays

Solutions on MaxInterview for sql calculate working days between two dates excluding weekends and holidays by the best coders in the world

Search
showing results for - "sql calculate working days between two dates excluding weekends and holidays"
Mathilda
17 Nov 2016
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');
similar questions
sql check if date is between 2 datessql select between two datessql get number of days between two datessql hours between two datesdate 3 months from today sqlsql list dates between two datessql select data from last weekdate sql get the last week countsql server current date minus 5 yearshow to get number of months between 2 dates sql serversql week commencing datesql get latest of 2 datetimesadd two days to current date in sql when creating tableshow to get the date diff on once field in sql serversql date between one weekselect the date 30 days less that the todays date sql requestdate difference in number of days sql serverhow to get the date diff of 2 dates in the same fieldin sql server
queries leading to this page
oracle list dates without weekendsreturn number of days between two dates in oracle sqlhow to calculate number of days between two dates in oraclesql calculate working days between two dates excluding weekends and holidaysoracle sql select all days between two dates except weekendshow to calculate number of days between two dates excluding weekends in oraclequery to find number of days between two dates in oraclesql calculate working days between two dates excluding weekends and holidays