[SQL] Re: Querying date interval

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

[SQL] Re: Querying date interval

2001-01-15 Thread J.H.M. Dassen (Ray)
On Mon, Jan 15, 2001 at 12:19:56 -0200, Renato De Giovanni wrote: > 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 "unstabl