Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
SELECT TIME(99991231235957), TIME(99991231235958), TIME(99991231235959); |
+----------------------+----------------------+----------------------+
|
| TIME(99991231235957) | TIME(99991231235958) | TIME(99991231235959) |
|
+----------------------+----------------------+----------------------+
|
| 23:59:57 | 23:59:58 | 838:59:59 |
|
+----------------------+----------------------+----------------------+
|
The expected result for the last column is 23:59:58.
Attachments
Issue Links
- blocks
-
MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP
- Closed