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 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: FIND MONTHS
Next Topic: Extracting just text from a Blob Column
Goto Forum:
  


Current Time: Fri Mar 29 17:23:36 CDT 2024