Time is valid in 5.2 but not 5.3
Hi,
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?
Subject
Written By
Posted
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.