How can PHP developers ensure that date and time values retrieved from a database are displayed in the desired format?

When retrieving date and time values from a database in PHP, developers can ensure they are displayed in the desired format by using the date() function to format the output. By specifying the desired format within the date() function, developers can control how the date and time values are displayed on the webpage. 

// Retrieve date and time value from the database
$timestamp = $row['timestamp'];

// Format the date and time value as desired
$formatted_date = date('Y-m-d H:i:s', strtotime($timestamp));

// Display the formatted date and time value on the webpage
echo $formatted_date;

Keywords

PHP date format database retrieval datetime formatting

Related Questions