Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: date retrieval
frank_at_webtecsinc.com schrieb:
> Thank you for the reply. However, that just returns 5, for Thursday. > > DA Morgan wrote:
SQL> SELECT days , to_char(days,'Day') days_w FROM (
2 SELECT DATE '2006-01-05' -1 + ROWNUM days
3 FROM dual
4 CONNECT BY LEVEL <= DATE '2006-01-11' - DATE '2006-01-05' +1)
5 WHERE to_char(days,'D') IN ('6','7')
6 /
DAYS DAYS_W
------------------ ------------------------------------ 06-JAN-06 Friday 07-JAN-06 Saturday
Best regards
Maxim Received on Thu Oct 19 2006 - 12:25:18 CDT