Skip to Main Content

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!

Creating a business hours function - To exclude holidays as well as weekends

soufirJan 19 2016 — edited Oct 15 2019

i want to create a function for business minutes / hours between two dates by  exclude holidays as well as weekends

weekends fri and sat

working hours 8:00 AM to 8:00 PM

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2019
Added on Jan 19 2016
14 comments
2,290 views