Working Days..

From: Vijays <srinivasanvijay_2000_at_yahoo.com>
Date: 19 Nov 2003 21:17:47 -0800
Message-ID: <fe3d44d1.0311192117.1fe8252d@posting.google.com>

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

Rgds Received on Wed Nov 19 2003 - 23:17:47 CST