Re: How to calculate time difference excluding weekends (saturday and sunday)

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Wed, 30 Apr 2008 07:29:31 -0700 (PDT)
Message-ID: <3c93ac69-b96d-40c6-b3ee-c08dc0df8980@r66g2000hsg.googlegroups.com>


On Apr 30, 9:49 am, deepakp <deepak10..._at_hotmail.com> wrote:
> I have an Oracle table that has 2 Date fields..i.e. the data type -
> DATE
>
> Field 1:  START_DATE sample value  "2008-04-04 12:00:00";
> Field 2:  END_DATE  sample value  "2008-04-07 05:46:07";
>
> If I subtract one date from another, I can get the time difference.
>
> Round((END_DATE - START_DATE), 4) AS TOTAL_DAYS
>
> The above results in 3.7404
>
> Between 2008-04-04 and 2008-04-07, there is Saturday and Sunday which
> are 2008-04-05 and 2008-04-06.
> I would like them to be excluded.
>
> Hence, the resultant that I'm looking for should be 1.7404  -- not
> 3.7404
>
> Is there a simple way to get the desired solution?
>
> Thanks,
> Deepak

Have you tried a Google search of the Usenet archives, or even a regular Google search?

http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/5a8545a4f3698ee0
http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/cad8621182ae7d1b
http://www.google.com/search?hl=en&q=site%3Aasktom.oracle.com+weekends+business+days

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Wed Apr 30 2008 - 09:29:31 CDT

Original text of this message