Is your field "submission" a date or a datetime value? I suspect the
MySQL seems to make a datetime from '1999-05-31' be '1999-05-31
00:00:00' in all comparisons. It seems to me that it would make more
sense to promote the date based on the direction of comparison. For
example, when comparing < it should be treated as "1999-05-31
23:59:59" and when compared as > it should be the way it is currently.
You can work around this by properly specifying your BETWEEN to
compare the full datetime if your field is a datetime.
>>>>> "JM" == Jeff Magnusson <jeff@stripped> writes:
JM> I'm doing a select to get a monthly set of data, and it appears that if I do
JM> "date BETWEEN '1999-05-01' and '1999-05-31'" the data for the 31st isn't
JM> included. Here's a clip where the only thing I change between selects is
JM> the upper limit on the BETWEN:
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/