Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: date retrieval
Thank you for the reply. However, that just returns 5, for Thursday.
DA Morgan wrote:
> frank_at_webtecsinc.com wrote:
> > How would I go about retrieving all Friday and Saturday dates between
> > two dates, say 5/1/06 and 11/1/06?
>
> By using TO_CHAR in the following fashion:
>
> SELECT TO_CHAR(SYSDATE, 'D') FROM dual;
>
> and filter for the values 6 or 7.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Thu Oct 19 2006 - 11:59:49 CDT