MySQL Forums
Forum List  »  Connector/ODBC

Re: Time is valid in 5.2 but not 5.3
Posted by: Bogdan Degtyariov
Date: March 07, 2019 09:17AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Time is valid in 5.2 but not 5.3
March 07, 2019 09:17AM


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.