>>>>> "CMC" == Claudia M Castaneda <claudia@stripped>
CMC> Well, it worked!!
CMC> Now, if you would be kind enough to explain us what is in a +0???
For the same reason that
select obs_id, obs_URI, obs_source, beg_date, beg_time from
observation where beg_date between '1999-01-20' and '1999-05-30';
will work. The automagic type conversion from strings to numbers in
MySQL seems to fail in this instance when comparing a string type to
numbers with "BETWEEN".
By adding the +0, you explicitly converted the date to a number type.
In my example, I made the values for the BETWEEN into strings, which
are treated nicely as DATEs.
I don't know which is faster, though.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
PGP & MIME spoken here http://www.kciLink.com/home/khera/