How can PHP handle date conversion and formatting without displaying the current date instead of the database date?

When retrieving dates from a database in PHP, the dates may be displayed as the current date due to timezone discrepancies. To handle date conversion and formatting correctly without displaying the current date, you can set the timezone in PHP to match the timezone of your database when retrieving and displaying dates.

// Set the timezone to match the database timezone
date_default_timezone_set('YourDatabaseTimezone');

// Retrieve the date from the database
$databaseDate = '2022-01-01 12:00:00';

// Convert and format the date as needed
$convertedDate = new DateTime($databaseDate);
$formattedDate = $convertedDate->format('Y-m-d H:i:s');

echo $formattedDate;