I am trying to fill my table with data but I am having trouble with the datetimes (Incorrect datetime value error). My data is in this format
What kind of transformation is needed so that I can insert the right time in my database?
Here's an example which is not working. I am using MySQL 5.6.10
INSERT INTO table (id, created_at) VALUES (89208460, "2017-08-30 10:00:00-07:00");
SELECT NOW() gives me
2017-09-27 11:47:38, it's a