I have this date-time format coming from Twilio.
I want to convert this into this and insert into MySQL.
I have tried using
DATE_FORMAT() but didn't get success.
Edit: This is what I have tried.
UPDATE table_name date = DATE_FORMAT('2019-03-28T11:09:49.000Z', '%m/%d/%Y %H:%i:%s %c/%e/%Y %T') WHERE id = id;