Substracting Dates leaving out the weekends
This is a discussion on Substracting Dates leaving out the weekends within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi, Is there a way in Oracle 8i to substract dates like you did, but then leave out the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 11:18 AM
| ||||
| ||||
 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      |
|
04-08-2008, 11:18 AM
| ||||
| ||||
| Re: Substracting Dates leaving out the weekends On Feb 14, 11:06 am, "Dries" <dries...@gmail.com> wrote: > 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 A quick google gives http://book.itzero.com/read/others/0602/ OReilly.SQL.Cookbook.Dec.2005_html/0596009763/sqlckbk-CHP-8- SECT-3.html Basically, count the number of days, excluding those that translate to saturday or sunday. jg -- @home.com is bogus. http://www.gridtoday.com/grid/1266347.html |
Linear Mode
