Re: SQL Date Challenge

"Josh Berkus" <josh@agliodbs.com> writes:

> 
> SELECT ALL Wednesdays BETWEEN 5/1/01 AND 6/1/01;
> 

somthing like:

select date from xx where to_char(date,'fmdy') = 'wed';

hth,
Manuel.