Oracle Date Difference Excluding Weekends

[Richard Mendoza]

Hi,

I want to get the difference between two dates which will not include weekends, saturdays and sundays are not be included in the count.

Can this be solved by means of ann oracle query? or I need to create a function for this in oracle? If so,

Any idea? or maybe an algorithm for such?

Thanks!

[Jeanne Boyarsky]

Richard,
You are going to need to write a function for this. Scroll down on this list of Oracle date functions to the "date calculations" section. They have some examples.

[Avi Abrami]

Richard,
I searched the archives of the "comp.databases.oracle.*" newsgroups and found the following (which may be of help):

http://tinyurl.com/3qs24

Also found this (at the "Ask Tom" Web site):

http://tinyurl.com/57blj

Good Luck,
Avi.
[ April 13, 2005: Message edited by: Avi Abrami ]