Bug #27906 MySQL doesn't accept ISO8601 date
Submitted: 17 Apr 2007 23:27 Modified: 17 Apr 2007 23:41
Reporter: Sander Marechal Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[17 Apr 2007 23:27] Sander Marechal
I discovered that MySQL doesn't accept all ISO 8601 dates for a DATETIME column. Specifically, the format YYYYMMDDTHH:MM:SS which is used by XMLRPC processes isn't supported. MySQL will generate a warning and insert 0000-00-00 00:00:00 instead.

Adding support for this would enable people to insert XML-RPC dataTime's without converting it to a different format first.

How to repeat:
Try inserting a DATETIME format of YYYYMMDDTHH:MM:SS (e.g."20070418T01:28:00") into a DATETIME column and observe the warning and result.
[17 Apr 2007 23:41] MySQL Verification Team
Thank you for the bug report feature request.
[20 Oct 2017 15:16] Eli Boaz
This has been around 10 years and it isn't that difficult, why is this still a problem? And I would say while this is pretty easy to work around, it's annoying because this works perfectly fine on Postgres.