List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 29 1999 6:52pm
Subject:Re: 3.23 year() used with timestamp -bug
View as plain text  
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
Thread
3.23 year() used with timestamp -bugBalint TOTH29 Sep
  • Re: 3.23 year() used with timestamp -bugBob Kline29 Sep
    • Re: 3.23 year() used with timestamp -bugPaul DuBois29 Sep
  • 3.23 year() used with timestamp -bugMichael Widenius29 Sep
    • More tm_year, Was: 3.23 year() used with timestamp -bugPeter Strömberg30 Sep
      • More tm_year, Was: 3.23 year() used with timestamp -bugMichael Widenius30 Sep