List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 14 1999 6:15pm
Subject:Re: Y2k problem?
View as plain text  
>>>>> "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
Thread
Y2k problem?Dave Pugh14 May
  • Re: Y2k problem?Jim Faucette14 May
    • Re: Y2k problem?Michael Widenius14 May