What are the best practices for retrieving and formatting datetime values directly from a database in PHP?

When retrieving datetime values directly from a database in PHP, it is important to handle the formatting correctly to display the date and time in the desired format. One common approach is to use the DateTime class in PHP to format the datetime value retrieved from the database. 

// Retrieve datetime value from the database
$datetimeFromDB = '2022-01-15 14:30:00';

// Create a DateTime object and format it
$datetime = new DateTime($datetimeFromDB);
$formattedDatetime = $datetime->format('Y-m-d H:i:s');

echo $formattedDatetime;

Keywords

datetime database retrieval formatting PHP

Related Questions