Re: Working Days..

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 20 Nov 2003 08:56:51 +0100
Message-ID: <bphs9t$1oi6vd$1@ID-152732.news.uni-berlin.de>

"Vijays" <srinivasanvijay_2000_at_yahoo.com> schrieb im Newsbeitrag news:fe3d44d1.0311192117.1fe8252d_at_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

hi, You may add something like

AND RTRIM(TO_CHAR(your_date,'Day')) NOT IN ( 'Sunday','Saturday' )

hth, Jan Received on Thu Nov 20 2003 - 01:56:51 CST