Re: Adviise please

From: HansF <News.Hans_at_telus.net>
Date: Thu, 20 Oct 2005 20:19:45 GMT
Message-Id: <pan.2005.10.20.20.18.26.332452@telus.net>

On Thu, 20 Oct 2005 12:03:02 -0700, maruf.zubaer interested us by writing:

> I need assistance in creating an oracle function which will calculate
> DateTimeDiff in hours excluding weekends and holidays
> So if Statdate is 10/10/05 08:15:00 and EndDate 10/10/05 13:15:00 the
> result we get is 5.00 hrs
>

(date expression - date expression) results in a date difference expressed in days. Then you convert days to hours, minutes or seconds by one of the following:

	one day has 24 hours
	one day has 24*60 minutes
	one day has 24*60*60 seconds

You should be able to figure out how divide from this point ...

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Thu Oct 20 2005 - 15:19:45 CDT