mysql str_to_date incorrect datetime value issue

Question

I can't work out why mysql is not liking my datetime value?

mysql> select  STR_TO_DATE('2017-10-06T00:00:00', '%%Y-%%m-%%dT%%H:%%i:%%s');
+---------------------------------------------------------------+
| STR_TO_DATE('2017-10-06T00:00:00', '%%Y-%%m-%%dT%%H:%%i:%%s') |
+---------------------------------------------------------------+
| NULL                                                          |
+---------------------------------------------------------------+
1 row in set, 2 warnings (0.00 sec)

mysql> show warnings
    -> ;
+---------+------+--------------------------------------------------------------------------+
| Level   | Code | Message                                                                  |
+---------+------+--------------------------------------------------------------------------+
| Warning | 1411 | Incorrect datetime value: '2017-10-06T00:00:00' for function str_to_date |
| Warning | 1411 | Incorrect datetime value: '2017-10-06T00:00:00' for function str_to_date |
+---------+------+--------------------------------------------------------------------------+
2 rows in set (0.01 sec)

Any ideas??

Answer 1

Try:

SELECT STR_TO_DATE(
  '2017-10-06T00:00:00',
  '%Y-%m-%dT%H:%i:%s'
);

See db-fiddle.