MySQL Date time

[Tunday]

I currently have the date time in this format:

 

2015-07-05T09:50:38.0870000Z

 

How can I convert this into

 

2015-07-05 09:50:38, such that I can import this into mysql database?

[Ch0cu3r]

You will  need to reformat the date before inserting it in your query, example

$date = new DateTime('2015-07-05T09:50:38.0870000Z');
$dateFormatted = $date->format('Y-m-d h:i:s'); // reformat to YYYY-MM-DD HH:MM:SS (mysql datetime) format
echo $dateFormatted;