Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > How to calculat...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 6868 of 6989
Post > Topic >>

How to calculate time difference excluding weekends (saturday and

by deepakp <deepak10000@[EMAIL PROTECTED] > Apr 30, 2008 at 06:49 AM

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
 




 5 Posts in Topic:
How to calculate time difference excluding weekends (saturday an
deepakp <deepak10000@[  2008-04-30 06:49:28 
Re: How to calculate time difference excluding weekends (saturda
Charles Hooper <hooper  2008-04-30 07:29:31 
Re: How to calculate time difference excluding weekends (saturda
deepakp <deepak10000@[  2008-04-30 09:45:23 
Re: How to calculate time difference excluding weekends (saturda
Ken Denny <ken@[EMAIL   2008-04-30 12:21:12 
Re: How to calculate time difference excluding weekends (saturda
deepakp <deepak10000@[  2008-05-01 13:26:32 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 4:47:02 CDT 2008.