What are some common methods for formatting date values in PHP when retrieving data from a database?

When retrieving date values from a database in PHP, they are often in a standard format such as 'Y-m-d H:i:s'. However, you may want to format these dates differently for display purposes, such as 'd-m-Y' or 'M j, Y'. To do this, you can use the date() function in PHP to format the date values as needed. 

// Retrieve date value from database
$dateFromDatabase = '2022-01-15 14:30:00';

// Format date value for display
$formattedDate = date('d-m-Y', strtotime($dateFromDatabase));

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

Keywords

PHP date formatting database retrieval strtotime date()

Related Questions