List:Internals« Previous MessageNext Message »
From:Paul Cadach Date:July 11 2001 4:09pm
Subject:Re: date/time insert bug
View as plain text  
Hi,

----- Original Message -----
From: "Yuri Dario" <mc6530@stripped>
To: "MySQL internals" <internals@stripped>
Sent: Wednesday, July 11, 2001 8:38 PM
Subject: Re: date/time insert bug


> Hi Timothy,
>
> >The timestamp you are getting is not correct; MySQL expects the
> >timestamp number to be in a normalized format.  I mean, there
>
> I suppose you don't use OS/2 ;-)

May be conversion from datetime to string works wrong under OS/2 by
generating time as 24:00:00 and date less by one?

> I forgot to say that I did the test with MySQL 3.23.38: I should build
> a debug binary and try again.

At 3.23.28-gamma all works fine:

mysql> create temporary table test_table (
    -> d timestamp
    -> );
Query OK, 0 rows affected (0.16 sec)

mysql> insert into test_table values ('2001-07-11 00:00:00');
Query OK, 1 row affected (0.00 sec)

mysql> select * from test_table;
+----------------+
| d              |
+----------------+
| 20010711000000 |
+----------------+
1 row in set (0.00 sec)

mysql>


Thread
date/time insert bugYuri Dario11 Jul
  • Re: date/time insert bugTimothy Smith11 Jul
    • Re: date/time insert bugYuri Dario11 Jul
      • Re: date/time insert bugPaul Cadach11 Jul
        • Re: date/time insert bugYuri Dario11 Jul