Re: date retrieval

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