SELECT whatever from xx where extract(dow from date) = 3;
LER
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 6/4/01, 1:03:11 PM, Manuel Sugawara <masm@fciencias.unam.mx> wrote
regarding Re: [SQL] 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.
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org