Photo by Emile Perron on Unsplash

Convert a date from YYYY-MM-DD to DD-MM-YYY format to display in PHP

Use the strtotime() Function

You can first use the PHP strtotime() function to convert any textual datetime into Unix timestamp, then simply use the PHP date() function to convert this timestamp into the desired date format.

The following example will convert a pre-defined date from yyyy/mm/dd to dd/mm/yyyy format. Instead of the pre-defined date that's used in the example, you may replace the posted date variable ($post_date) that is stored in mysql database.

Then you will get the desired date format output and can include times format such as hours, minutes, seconds and AM/PM.

<?php
$post_date = "2020/01/18, 9:45:00"; // you may replace posted date variable ($post_date) that stored in mysql database

// Creating timestamp from given date
$timestamp = strtotime($post_date);

// Creating new date format from that timestamp
$new_date = date("d/m/Y, g:i A", $timestamp);
echo $new_date; // Outputs: 18/01/2020, 9:45AM
?>

Example date() Formatting for your ref

<?php
// Assuming today is March 10th, 2001, 5:16:18 pm, and that we are in the
// Mountain Standard Time (MST) Time Zone

$today = date("F j, Y, g:i a");                 // March 10, 2001, 5:16 pm
$today = date("m.d.y");                         // 03.10.01
$today = date("j, n, Y");                       // 10, 3, 2001
$today = date("Ymd");                           // 20010310
$today = date('h-i-s, j-m-y, it is w Day');     // 05-16-18, 10-03-01, 1631 1618 6 Satpm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // it is the 10th day.
$today = date("D M j G:i:s T Y");               // Sat Mar 10 17:16:18 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');     // 17:03:18 m is month
$today = date("H:i:s");                         // 17:16:18
$today = date("Y-m-d H:i:s");                   // 2001-03-10 17:16:18 (the MySQL DATETIME format)
?>

For more detail, please visit here >> https://www.php.net/manual/en/function.date.php