How to format date and time from mysql to php?

Question

PHP

It is necessary to turn the received date and time "2015-12-12 12:12:12" into "12/12/2015 at 12:12". Tried like this date('d.m.Y H:i', $x[0]['time']), but there are completely different date, time, and even an incomprehensible indent from above.

Answer 1

echo date("d-m-Y H:i:s", strtotime("2015-12-12 12:12:12"));

Answer 2

And who's stopping you from getting the date immediately in the right format via DATE_FORMAT() ?
so or

$date = date_create($x[0]['time']);
echo date_format($date, 'd.m.Y H:i');

Answer 3

$new_time = str_replace("-", ".", $x[0]['time']);