How to get the date and time from the database by DD MM YYYY HH MM?

Question

PHP

I save the date and time in the database, but it is saved as 2020-05-24 14:01:04

How to make it show on the page as 24-05-2020 14:01:04 ?

Answer 1

<?php
$date = strtotime("2020-05-24 14:01:04");
echo date("d-m-Y G:i:s", $date);

Answer 2

MySQL DATE_FORMAT() Function