Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007

    Unanswered: How to check the working days using Date function

    Hi guys, need your help on this matter.

    Basically I need to retrieve the working days from two specific dates. For example on 06-march-2007 and 21-may-2007. what is the code i could use to retrieve this information. I had done a check myself but then it only check the date day by day and it is rather taxing on my system. Can you all help by giving me suggesstions on how to handle the statement so that i can retrieve the values and check by weekly basic rather than day by day as it would improve the performance of my system. Thanks.... your help is deeply appreciated..


  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    Do you need to take (country specific) holidays into account?

    If so, then I don't think there is a built-in solution for this, as Oracle will not know which days are holidays and which are not.

    This link might help you in case holidays are not relevant:

    More information here:

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    May 2007
    hey guys, thanks i m working on it...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts