OraFAQ Forum: SQL & PL/SQL » Finding Business days in a month.

Home » SQL & PL/SQL » SQL & PL/SQL » Finding Business days in a month.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Finding Business days in a month. [message #19773]

Tue, 09 April 2002 03:28

Manoj Mone
Messages: 1
Registered: April 2002

Junior Member

Hi All,
For a forecasting report I need to find out number of Business days in a given month. Is anyone aware of any Oracle / sql function that can do this?

Eg. for April 2002 it should give me 22 days.the weekend days 2 per week should'nt be counted.

Thanks in Advance
Manoj.

Report message to a moderator

Re: Finding Business days in a month. [message #19774 is a reply to message #19773]

Tue, 09 April 2002 04:33

Epe
Messages: 99
Registered: March 2002

Member

Hello,

if you want a calendar with business days, you'll have to make it yourself I'm affraid. That seems logical to me, since business days are dependend from business to business or country to country...
How you make such a calendar ?
The Oracle Manuals give an example on :
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/inter.817/a67294/ts_tsuse.htm#626237

Success,

epe

Report message to a moderator

Re: Finding Business days in a month. [message #19780 is a reply to message #19773]

Tue, 09 April 2002 09:22

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:673848::NO::F4950_P8_DISPLAYID

Report message to a moderator

Previous Topic:	presentation on performance tuning
Next Topic:	passing varable in a sql statament

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 07:14:26 CDT 2024