SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to count days in between 2 dates excluding weekends?

User_R6EDAMay 17 2022 — edited May 17 2022

Example:
In table Orders I have fields approved_date and creation_date. I want to count how many days between both dates.
approved_date | creation_date | approved - creation
05/16/2022 | 05/12/2022 | 4

Expected Output excluding Saturday and Sunday.:
approved_date | creation_date | approved - creation
05/16/2022 | 05/12/2022 | 2

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2023

Added on May 17 2022

#sql

4 comments

8,822 views

1 mention