Oracle-L: RE: NEXT BUSINESS DAY

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 07 Oct 2003 15:24:26 -0800
Message-ID: <F001.005D24CB.20031007152426@fatcity.com>

Hamid

You might consider creating a table in Oracle that will list all days and whether it is a business day or not. Eventually you can create a screen so a user can take responsibility for keeping that table corrected, since for many businesses there are slight differences in the holiday schedule each year, and you probably don't want to be responsible for adjusting an algorithm each year.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, October 07, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L

List,

any body know any module or reference to get the next business day including holidays etc.
Thanks,

Hamid Alavi

Office : 818-737-0526
Cell phone : 818-416-5095

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hamid Alavi
INET: hamid.alavi_at_quovadx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------