Home » SQL & PL/SQL » SQL & PL/SQL » SQL to Subtract X workdays from a date (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
SQL to Subtract X workdays from a date [message #671090] |
Wed, 15 August 2018 06:37 |
|
ssmith001
Messages: 37 Registered: August 2018
|
Member |
|
|
I have a need to subtract x number of weekdays from a date.
For example: RoutingDueByDate = PO_Due_Date - 5 business days, so if PODueDate = 8/15/18, then the calculation needs to yield a result of 8/8/18
Does anyone have an idea on how to write the code to do this subtraction, without needing to use a function, which I don't have permissions to write into the db.
|
|
|
Goto Forum:
Current Time: Fri Mar 29 17:23:36 CDT 2024
|