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 f0FEDM073974 for ; Mon, 15 Jan 2001 09:13:23 -0500 (EST) (envelope-from rdg@viafractal.com.br) Received: (qmail 4595 invoked from network); 15 Jan 2001 14:13:17 -0000 Received: from unknown (HELO viafractal.com.br) (200.192.49.189) by rush.u-netsys.com.br with SMTP; 15 Jan 2001 14:13:17 -0000 Message-ID: <3A63070C.F2661FED@viafractal.com.br> Date: Mon, 15 Jan 2001 12:19:56 -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: Querying date interval Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/140 X-Sequence-Number: 801 Hi, Is there any SQL workaround to get the right results from the select statement bellow? Or am I doing something wrong?? 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) Thanks in advance! -- Renato Sao Paulo - SP - Brasil rdg@viafractal.com.br