What is the recommended method to convert a DateTime value to a Timestamp in PHP when retrieving data from a MySQL database?

When retrieving a DateTime value from a MySQL database in PHP, it is recommended to convert it to a Timestamp to ensure consistency and compatibility with other date/time functions. This can be achieved by using the strtotime() function in PHP, which converts a human-readable date/time string to a Unix timestamp. 

// Retrieve DateTime value from MySQL database
$datetimeFromDB = "2022-01-01 12:00:00";

// Convert DateTime to Timestamp
$timestamp = strtotime($datetimeFromDB);

// Output Timestamp
echo $timestamp;

Keywords

PHP DateTime Timestamp MySQL conversion

Related Questions