How can PHP be used to format the date retrieved from a MySQL database to a specific format, such as DD.MM.YYYY HH:MM?

To format the date retrieved from a MySQL database to a specific format like DD.MM.YYYY HH:MM, you can use the PHP date() function along with strtotime() to convert the date string from the database into the desired format. You can fetch the date from the database, convert it using strtotime(), and then format it using date(). 

// Assuming $row['date'] contains the date retrieved from MySQL
$dateFromDB = $row['date'];

// Convert the date to the desired format
$formattedDate = date('d.m.Y H:i', strtotime($dateFromDB));

echo $formattedDate;

Keywords

PHP MySQL date formatting date function specific format

Related Questions