Bug #6026 ODBC TIME type error when inserting 01:00:00
Submitted: 11 Oct 2004 13:03 Modified: 24 Oct 2005 21:04
Reporter: Hartmut Holzgraefe Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Peter Harvey CPU Architecture:Any

[11 Oct 2004 13:03] Hartmut Holzgraefe
When trying to insert a time value into a table with a prepared statement, I got a
[MySQL][ODBC 3.51 Driver][mysqld-3.23.48-Max-log]You have an error in your SQL syntax near ''100:00:00)' at line 1
error message.
My MyODBC version 3.51.06

You may have also a look at http://www.openoffice.org/issues/show_bug.cgi?id=30577 where this bug is described. 

How to repeat:
see http://www.openoffice.org/issues/show_bug.cgi?id=30577
[15 Oct 2004 7:56] Jose Plata
If you insert '00:00:01' the record save as '01:00:00' and if you reediting the record i have same problem.
[29 Sep 2005 16:55] David L Lambert
I cannot reproduce this bug on the following configuration:

OOo 2.0beta (1.9.104)
MySQL Connector/J 3.1.10
Sun JDK 1.5.0_04
MySQL 4.11.1  OR  MySQL 5.0.12-beta