For future reference, does this effect order by clauses in the way one would expect? (ie., 00 precedes 01). The docs make it seem as though use of invalid dates results in undefined behavior.
Can you indicate which part of the docs you're referring to? Thanks.
Well, I guess I should just say the expected behavior is not described by the docs. Claims such as these:
"The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. (``Supported'' means that although earlier values might work, there is no guarantee that they will.)"
and
"Illegal DATETIME, DATE, or TIMESTAMP values are converted to the
``zero'' value of the appropriate type ('0000-00-00 00:00:00',
'0000-00-00', or 00000000000000)."along with the many warnings against using values that could be interpreted as times rather than dates or visa versa under relaxed interpretation situations would make me very leary about using anything that is not clearly a valid date, and somewhat uncertain as to what mysql will do with the data under the hood.
(all that and much more available at: http://www.mysql.com/doc/en/DATETIME.html)
-bluejack
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
