mysql> select @@sql_mode;

+--------------------------------------------+

| @@sql_mode                                 |

+--------------------------------------------+

| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |

+--------------------------------------------+

1 row in set (0.00 sec)

mysql> insert into datetimetest(dt) values ('2013-08-26T12:00:00+00:00');

ERROR 1292 (22007): Incorrect datetime value: '2013-08-26T12:00:00+00:00' for column 'dt' at row 1

-- remove STRICT_TRANS_TABLES -- note that executing this only removes it for your

-- current session -- it does not make a server-wide config change

mysql> set @@sql_mode='no_engine_substitution';

Query OK, 0 rows affected (0.00 sec)

mysql> select @@sql_mode;

+------------------------+

| @@sql_mode             |

+------------------------+

| NO_ENGINE_SUBSTITUTION |

+------------------------+

1 row in set (0.00 sec)

-- now MySQL will accept the invalid value, with a warning

mysql> insert into datetimetest(dt) values ('2013-08-26T12:00:00+00:00');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show warnings;

+---------+------+-----------------------------------------+

| Level   | Code | Message                                 |

+---------+------+-----------------------------------------+

| Warning | 1265 | Data truncated for column 'dt' at row 1 |

+---------+------+-----------------------------------------+

1 row in set (0.00 sec)

-- the value did get inserted, but the time zone information was lost:

mysql> select * from datetimetest;

+----+---------------------+

| id | dt                  |

+----+---------------------+

|  1 | 2013-08-26 12:00:00 |

+----+---------------------+

1 row in set (0.00 sec)