MySQL Forums
Forum List  »  Connector/ODBC

Time is valid in 5.2 but not 5.3
Posted by: Steven Taylor
Date: February 25, 2019 10:50AM


I am writing software which uses MySql via ODBC. Our Windows system is using 5.2 and our Linux one is using 5.3 (both are using MySql version 5.1.73 and access the same server).

I am getting an issue with one of our tests. In Windows the command:

Insert into tableName values ('24:00:00');

works but it fails in Linux with the error:

[MySQL][ODBC 5.3(a) Driver][mysqld-5.1.73]Not a valid time value supplied

The database column is a Time type and the query works via the MySql command line tool on Linux.

Has the time validation changed between these versions?

Options: ReplyQuote

Written By
Time is valid in 5.2 but not 5.3
February 25, 2019 10:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.