How can one correctly convert a MySQL timestamp to a Unix timestamp in PHP?

To convert a MySQL timestamp to a Unix timestamp in PHP, you can use the strtotime() function to parse the MySQL timestamp and then use the date() function to format it as a Unix timestamp. This allows you to easily convert the timestamp from one format to another for further processing or comparison. 

$mysql_timestamp = "2022-01-01 12:00:00";
$unix_timestamp = strtotime($mysql_timestamp);
echo $unix_timestamp;

Keywords

MySQL timestamp Unix timestamp PHP conversion function

Related Questions