October 1st, 2003, 06:34 PM
Want PL/SQL help to do the following.
I want to add 15 business days from today while I query. How do I do this?
Any help appreciated.
Last edited by sowsam; October 1st, 2003 at 06:36 PM.
October 2nd, 2003, 03:08 PM
Since a business week is usually considered to be Monday through Friday which are 5 days, 15 days would be exactly three weeks. Meaning sysdate+21 should give you the proper date. Now, what about holidays? That makes it more complex.
October 2nd, 2003, 03:19 PM
Thanks! Dan. This should help. And we are not considering a holidays table.. thanks again.