Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.6.2
-
None
-
Linux, MariaDB 10.3, MariaDB 10.5
Description
SEC_TO_TIME should support converting seconds to the TIME data type, inside the representation limits of the TIME data type.
However, it looks like the JDBC connector wraps the result at 24 hours.
E.g. using the `mariadb` client:
MariaDB [(none)]> SELECT SEC_TO_TIME(257394);
---------------------
SEC_TO_TIME(257394) ---------------------
71:29:54 ---------------------
E.g. using the JDBC connector to execute the same query:
23:29:54
(i.e. 71:29:54 minus 2*24h)
It might be interesting to note that the MySQL JDBC connector returns `NULL` for the same query.