| eliminate weekend when counting no. of days [message #2655] |
Sun, 04 August 2002 18:30  |
ga
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
hi,
i just wanna ask how to eliminate weekends when counting number of days.
Example:
Aug. 1, 2002 to Aug. 8, 2002 should return 5 days instead of 7 because Aug. 3 is saturday and Aug. 4 is sunday.
thanks
|
|
|
|
| Re: eliminate weekend when counting no. of days [message #2657 is a reply to message #2655] |
Sun, 04 August 2002 22:52  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
hi,
you can use decode function to solve u'r problem.following query can solve u'r problem.
THIS QUERY INCLUDES THE DATE FROM '1-AUG-02' TO
'8-AUG-02'
select SUM(decode(ltrim(rtrim(to_char(to_date('1-aug-02','dd-mon-rr')+ROWNUM-1,'DAY'))),'SATURDAY',0,'SUNDAY',0,1)) "NO. OF DAYS"
FROM ALL_OBJECTS WHERE to_date('1-aug-02','dd-mon-rr')+ROWNUM-1<=TO_DATE('8-AUG-02','DD-MON-RR');
RESULT WILL RETURN 6 .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
