Re: [SQL] Querying date interval

2001-01-15 Thread Renato De Giovanni
> > 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 > > -

Re: [SQL] Querying date interval

2001-01-15 Thread Richard Huxton
- Original Message - From: "Renato De Giovanni" <[EMAIL PROTECTED]> > 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' ; > >

Re: [SQL] Querying date interval

2001-01-15 Thread Tom Lane
Renato De Giovanni <[EMAIL PROTECTED]> 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-

[SQL] Querying date interval

2001-01-15 Thread Renato De Giovanni
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'); sel