>>>>> "Jim" == Jim Faucette <jimf@stripped> writes:
Jim> Dave Pugh wrote:
>>
>> Has this caught anyone else's attention?
>>
>> >From the Y2k section (1.6) of the MySQL manual at
>> http://www.tcx.se/Manual_chapter/manual_Introduction.html#Year_2000_compliance
>>
>> They inserted this line:
>> INSERT INTO y2k VALUES ("1999-01-01","1999-01-01 00:00:00",19990101000000);
>>
>> And the select produced this line:
>> | 1999-01-01 | 1999-01-01 00:00:00 | 19981231000000 |
>> ^^^^^^^^^^^^^^
>>
>> Notice that the timestamp (last field) entered differs by one day from
>> what came out of the select?
>>
Jim> That must be a typo in the manual. 3.22.20a returns the entered data.
Hi!
I must confess I don't know how it's possible that the manual entry is
wrong (and also why no one has noticed this before).
I also checked this and MySQL 3.22.22 returns the correct timestamp.
(I am not even aware of a single MySQL version that have had this problem)
Regards,
Monty
