Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > oracle > answers

Business days calc

Newbie
  
Join Date: Jul 2009
Posts: 2
#1: Jul 29 '09
How do i write a function to calculate business days excluding weekends and holidays in oracle?
Actually i need to prepare a calendar for my monthly activities i.e activity x to be performed on 3rd workingday of month.
Can u please help me out with this as i am very new to oracle.
Plzzzzzzz
debasisdas's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,497
#2: Jul 29 '09

re: Business days calc

check the following link , you can modify the code as per your requirement.
Reply

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved