What are the potential pitfalls of using Unix-Timestamp as a date/time value in PHP and MySQL?

Using Unix Timestamp as a date/time value in PHP and MySQL can lead to issues when trying to perform date/time calculations or conversions. It is recommended to store date/time values in MySQL as a DATETIME data type instead of Unix Timestamps to avoid potential pitfalls. 

// Storing date/time as DATETIME in MySQL
$datetime = date('Y-m-d H:i:s');
$query = "INSERT INTO table_name (datetime_column) VALUES ('$datetime')";
mysqli_query($connection, $query);

Keywords

Unix-Timestamp date/time PHP MySQL pitfalls

Related Questions