Time is valid in 5.2 but not 5.3

[Steven Taylor]

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?