Re: Working Days..

> SELECT
> REPDATE,CLOSEDDATE,
> TRUNC(CLOSEDDATE)-TRUNC(REPDATE)+1 TOTDAYS,
> CRITICALITY
> FROM ISSUE
> WHERE
> TISSUE = 'Defect'
>
> This is my select statement..
>
> REPORTEDDATE CLOSEDATE TOTDAYS CRITICALITY
> 05-Feb-02 05-Feb-02 1 High
> 08-Feb-02 08-Feb-02 1 Medium
> 30-Jan-02 09-Feb-02 11 Medium -->i want 9
> 09-Feb-02 09-Feb-02 1 Medium
> 11-Feb-02 11-Feb-02 1 Medium
> 11-Feb-02 11-Feb-02 1 Medium
> 11-Feb-02 11-Feb-02 1 Medium
> 28-Sep-02 28-Sep-02 1 Medium
> 30-Sep-02 30-Sep-02 1 Medium
> 30-Sep-02 03-Oct-02 4 Medium
> 30-Sep-02 03-Oct-02 4 Medium
> 30-Sep-02 30-Sep-02 1 Medium
> 30-Sep-02 04-Oct-02 5 Medium
>
> This is the output...when i get the totdays i wanted to exclude the sat and
> sun..

I once have written a procedure: 'add_working_days' that you can find on my website:

http://www.adp-gmbh.ch/ora/plsql/add_working_days.html

Maybe, this helps you solve your problem

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch