Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
12.1.2
-
None
-
Not for Release Notes
Description
the hour value is out of range 0-24,affected by adding function
mysql> select hour(time '03:24:35'+ INTERVAL '24' hour); |
+-------------------------------------------+
|
| hour(time '03:24:35'+ INTERVAL '24' hour) | |
+-------------------------------------------+
|
| 27 | |
+-------------------------------------------+
|
1 row in set (0.00 sec) |
Version
mysql> select version();
|
+------------------------+
|
| version() |
|
+------------------------+
|
| 12.1.2-MariaDB-ubu2404 | |
+------------------------+
|
1 row in set (0.00 sec) |