Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Incomplete
-
5.5.31
-
None
-
None
-
None
-
CentOS 6.4 x64
Description
When trying to input an ISO8601 string as a datetime value, the SQL query fails.
UPDATE `users` SET `activity` = '2013-06-07T18:15:51+0800' WHERE id = '1';
|
Invalid datetime format: 1292 Incorrect datetime value: '2013-06-07T18:15:51+0800' for column 'activity' at row 1
|
This works in MySQL 5.5 (tried with 5.5.29).