'How to get the next business day if the current date is holiday in oracle? [duplicate]
I Need to find out the next business in oracle if the todays date is holiday. There are two different scenarios, need help in writing the logic for these scenarios at once.
If the todays date is 1/17/2022, since it is holiday(Martin Luther King Day) i want to show the date as 1/18/2022 in the output which is nothing but next business day.
If the todays date is 05/31/2021, since it is holiday(Memorial Day), at the time next business falls into next month 01/06/2021. Since it is falling into next month, i want to show the previous business day of holiday 5/28/2021 in the output.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|