What is the recommended approach for converting date formats in PHP, especially when retrieving dates from a MySQL database?

When retrieving dates from a MySQL database in PHP, it's common to encounter different date formats. To convert these dates to a desired format, you can use the DateTime class in PHP. This class provides methods to easily manipulate and format dates according to your requirements. 

// Retrieve date from MySQL database
$dateFromDatabase = "2022-01-15";

// Convert date format using DateTime class
$dateTime = new DateTime($dateFromDatabase);
$formattedDate = $dateTime->format('Y-m-d');

echo $formattedDate; // Output: 2022-01-15

Keywords

PHP date format MySQL database conversion recommended approach

Related Questions