List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 29 2000 2:04pm
Subject:Re: BETWEEN doesn't work with dates like "2000-1-3"
View as plain text  
>>>>> "Oliver" == Oliver Billmann <oliver@stripped> writes:

>> >From the manual:
Oliver> [...snip...]

>> Note that this doesn't mention anything about special comparison for
>> dates;  The date/datetime/timestamp is simply converted to a string
>> and compared as a string;  This is the source of the problem!

Oliver> Now that you explained it, it makes sense... I actually read the chapter
Oliver> about the representation of date values just before reading the above.
Oliver> That's probably why I missed that one... (and assumed it works everywhere)

>> Anyway, I have however fixed this problem in the upcoming MySQL 3.23.9
>> release...

Oliver> Great :-)  Will you release a patch for MySQL 3.22 as well?

After it has been in 3.23 for a couple of weeks we can backport the
patch.  (We don't want to accidently break 3.22 :)

Regards,
Monty
Thread
BETWEEN doesn't work with dates like "2000-1-3"Oliver Billmann18 Jan
  • BETWEEN doesn't work with dates like "2000-1-3"Michael Widenius26 Jan
    • Re: BETWEEN doesn't work with dates like "2000-1-3"Oliver Billmann26 Jan
      • Re: BETWEEN doesn't work with dates like "2000-1-3"Michael Widenius28 Jan
        • Re: BETWEEN doesn't work with dates like "2000-1-3"Oliver Billmann28 Jan
          • Re: BETWEEN doesn't work with dates like "2000-1-3"Michael Widenius29 Jan