Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0FFF2078382 for ; Mon, 15 Jan 2001 10:15:02 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0FFEsJ25503; Mon, 15 Jan 2001 10:14:55 -0500 (EST) To: Renato De Giovanni cc: pgsql-sql@postgresql.org Subject: Re: Querying date interval In-reply-to: <3A63070C.F2661FED@viafractal.com.br> References: <3A63070C.F2661FED@viafractal.com.br> Comments: In-reply-to Renato De Giovanni message dated "Mon, 15 Jan 2001 12:19:56 -0200" Date: Mon, 15 Jan 2001 10:14:54 -0500 Message-ID: <25500.979571694@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/142 X-Sequence-Number: 803 Renato De Giovanni writes: > create table testdate (field1 date); > insert into testdate values ('2000-09-30'); > insert into testdate values ('2000-10-20'); > insert into testdate values ('2000-11-25'); > 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) Curious. I can't reproduce this error in EST5EDT timezone, using either 7.0.2 or current. What PG version are you using, and with what timezone setting? Is 2000-09-30 or 2000-10-01 a daylight-savings transition date in your timezone? regards, tom lane