Sorry ,
You were right. I was mistaken the results
Between works just fine. It was me.
I'm Very sorry
Thank you all
On Thu, 2004-09-23 at 15:45, Mauricio Pellegrini wrote:
> Thanks,but I've also tried the date() function
> to compare only the date part of the column
>
> like this
>
>selec
Thanks,but I've also tried the date() function
to compare only the date part of the column
like this
select * where date(date_col) between date(startdate) and
date(enddate)
and the result is the same.
On Thu, 2004-09-23 at 11:04, gerald_clark wrote:
> Mauricio Pellegrini wrote:
>
> >Hi,
Mauricio Pellegrini wrote:
Hi,
I'm using Between to fetch rows whose date column is between two dates.
The thing is, sometimes it brings all the rows including those with a
date similar to the upper limit ( which is the correct behaviour,
according to the manual)
and in other cases it brings a
Hi,
I'm using Between to fetch rows whose date column is between two dates.
The thing is, sometimes it brings all the rows including those with a
date similar to the upper limit ( which is the correct behaviour,
according to the manual)
and in other cases it brings al the rows excluding those e
