What are the advantages and disadvantages of using a UNIX timestamp to store dates in a MySQL database for a news archive?

Using a UNIX timestamp to store dates in a MySQL database for a news archive can be advantageous because it is a standardized format that is easy to work with and can be easily converted to different date formats. However, it may be less human-readable and may require additional conversion functions when displaying dates to users.

// Storing a date in a MySQL database using a UNIX timestamp
$timestamp = time(); // Get the current UNIX timestamp
$query = "INSERT INTO news_archive (title, content, date) VALUES ('Title', 'Content', $timestamp)";
$result = mysqli_query($connection, $query);