Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0GEkI092738 for ; Tue, 16 Jan 2001 09:46:18 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from rush.u-netsys.com.br (rush.u-netsys.com.br [200.192.48.10]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0G1Nr026171 for ; Mon, 15 Jan 2001 20:23:53 -0500 (EST) (envelope-from rdg@viafractal.com.br) Received: (qmail 26247 invoked from network); 16 Jan 2001 01:23:48 -0000 Received: from ppp25-pm3.u-netsys.com.br (HELO viafractal.com.br) (200.192.49.154) by rush.u-netsys.com.br with SMTP; 16 Jan 2001 01:23:48 -0000 Message-ID: <3A63A432.613AEC88@viafractal.com.br> Date: Mon, 15 Jan 2001 23:30:27 -0200 From: Renato De Giovanni X-Mailer: Mozilla 4.72 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Querying date interval References: <3A63070C.F2661FED@viafractal.com.br> <20010115153610.A30879@cistron-office.nl> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/170 X-Sequence-Number: 833 > > 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