Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.2.7
-
None
Description
It works with ADDTIME, but not when inserting.
MariaDB [(none)]> SELECT ADDTIME('2016-10-12T23:00:00Z', '1');
|
+--------------------------------------+
|
| ADDTIME('2016-10-12T23:00:00Z', '1') |
|
+--------------------------------------+
|
| 2016-10-12 23:00:01 |
|
+--------------------------------------+
|
1 row in set, 1 warning (0.00 sec)
|
|
|
MariaDB [(none)]> INSERT INTO db.table (start) VALUES ('2016-10-12T23:00:00Z');
|
ERROR 1292 (22007): Incorrect datetime value: '2016-10-12T23:00:00Z' for column 'start' at row 1
|
|
|
MariaDB [(none)]> INSERT INTO db.table (start) VALUES ('2016-10-12T23:00:00');
|
Query OK, 1 row affected (0.00 sec)
|
Inserting with a trailing Z does work in another db that is 10.1.19. What has changed? It's valid ISO8601 as far as I know.