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>
