Re: Querying date interval

> > select * from testdate where field1 between '2000-10-01' and
> > '2000-11-30' ;
> >
> >    field1
> > ------------
> >  2000-09-30   <---- why is it here??
> >  2000-10-20
> >  2000-11-25
>
> It works fine for me (7.0.3, Debian GNU/Linux "unstable").
>
> I suspect your problem has to do with the "DATESTYLE" setting you're using;
> does it help if you do "SET DATESTYLE TO 'ISO'" prior to INSERTing your test
> values?

Just reporting, I´ve tried: \set DATESTYLE ´ISO´ before adding values, but the
result is still wrong.

Thanks anyway,
--
Renato
Sao Paulo - SP - Brasil
rdg@viafractal.com.br