Re: Querying date interval

----- Original Message -----
From: "Renato De Giovanni" <rdg(at)viafractal(dot)com(dot)br>

> Hi,
>
> Is there any SQL workaround to get the right results from the select
> statement bellow? Or am I doing something wrong??
>
> 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
> (3 rows)
>
Someone else mentioned DATESTYLE - the other thing to check is that you
haven't got a local summertime adjustment on 30th Sep or 1st Oct - that
caused issues in some previous versions of postgres IIRC (have a rummage in
the archives)

- Richard Huxton