Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Substracting Dates leaving out the weekends

Substracting Dates leaving out the weekends

From: Dries <driescox_at_gmail.com>
Date: 14 Feb 2007 11:06:56 -0800
Message-ID: <1171480015.143538.286910@p10g2000cwp.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US