At 9:55 AM -0500 9/29/99, Bob Kline wrote:
>On Wed, 29 Sep 1999, Balint TOTH wrote:
>
>> Hi All!
>>
>> Just try this:
>>
>> use test;
>> create table tstest (a timestamp);
>> insert into tstest values (now());
>> select date_format(a,"%Y %y"),year(a),year(now()) from tstest;
>> drop table tstest;
>>
>> select output:
>> 0099,99,1999
>>
>> Do you guys know about this one? If you change the field type to
>> datetime, it works fine.
>>
>> 3.23.2-4 do have this bug, i don't know anything about earlier versions.
>>
>
>Version 3.22.25 (Linux 2.2.5-15):
>
>mysql> select date_format(a,"%Y %y"),year(a),year(now()) from tstest;
>+------------------------+---------+-------------+
>| date_format(a,"%Y %y") | year(a) | year(now()) |
>+------------------------+---------+-------------+
>| 1999 99 | 1999 | 1999 |
>+------------------------+---------+-------------+
>1 row in set (0.00 sec)
Right, but the problem does occur in the 3.23 series. I tried it
this morning on MySQL 3.23.4/LinuxPPC R5/Q3 and it happened to me as well.
By the way, 3.23.4 eliminates the problem with configure and big file
support that was causing such problems with corrupt grant tables as
mysql_install_db time. This is good to see!
--
Paul DuBois, paul@stripped
