Re: SQL Date Challenge

SELECT whatever from xx where extract(dow from date) = 3;

LER

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 6/4/01, 1:03:11 PM, Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> wrote
regarding Re: [SQL] SQL Date Challenge:

> "Josh Berkus" <josh(at)agliodbs(dot)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.

> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org