How does MySQL handle timestamps differently from UNIX timestamps in PHP?

MySQL handles timestamps differently from UNIX timestamps in PHP by storing them in a different format. MySQL timestamps are stored in the format 'YYYY-MM-DD HH:MM:SS' while UNIX timestamps are stored as integers representing the number of seconds since January 1, 1970. To handle this difference, we can use the PHP functions strtotime() to convert a MySQL timestamp to a UNIX timestamp and date() to convert a UNIX timestamp to a MySQL timestamp. 

// Convert MySQL timestamp to UNIX timestamp
$mysqlTimestamp = '2022-03-15 14:30:00';
$unixTimestamp = strtotime($mysqlTimestamp);

// Convert UNIX timestamp to MySQL timestamp
$unixTimestamp = time();
$mysqlTimestamp = date('Y-m-d H:i:s', $unixTimestamp);

Keywords

MySQL timestamps UNIX timestamps PHP handling

Related Questions