Re: Time is valid in 5.2 but not 5.3

[Bogdan Degtyariov]

Hi Steven,

Yes, the additional time validation was added into ODBC Driver 5.3 and 8.0 to comply with the ODBC specification. MySQL Server might allow time values such as '24:00:00', but they are not valid as per ODBC specs.

Here is the specification of ODBC data types:

https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/sql-data-types?view=sql-server-2017

As you can see for SQL_TIME it says the following:

SQL_TIME:

Hour, minute, and second fields, with valid values for hours of 00 to 23, valid values for minutes of 00 to 59, and valid values for seconds of 00 to 61. Precision p indicates the seconds precision.