Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Substracting Dates leaving out the weekends
Hi,
Is there a way in Oracle 8i to substract dates like you did, but then leave out the weekend-days. So if i substract two days like 14/02/2007-07/02/2004 normally I would get the result of 7days. The result I need is 5Days (Saturday and sunday left out).
Thank you very much in advance.
Greetings
Dries Cox Received on Wed Feb 14 2007 - 13:06:56 CST