| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Counting Weekdays
Paul,
You need to write one. In my previous job, we had a business_day table where we maintain all valid business days (since you can have a holiday between a Sunday and the following Saturday).
Thanks
Prakash
-----Original Message-----
From: Troiano, Paul (CAP, GEFA) [mailto:Paul.Troiano_at_gecapital.com]
Sent: Tuesday, December 05, 2000 1:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Counting Weekdays
Does a function already exist (in PL/SQL or elsewhere) that will count only business days (week days) between two dates?
For Ex.: 12:00 pm Dec. 5, 2000 minus 12:00 pm Dec. 1, 2000 = 4 days, However it is only 2 business days since the 2nd and 3rd are Sat. and Sunday.
If I don't find one, I will have to write one. I'd like to avoid that.
Thanks,
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Troiano, Paul (CAP, GEFA)
INET: Paul.Troiano_at_gecapital.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 14 2000 - 16:38:08 CST
 |
 |