What are the different methods to handle timestamps in PHP and MySQL queries?

When working with timestamps in PHP and MySQL queries, it's important to ensure that the timestamps are handled consistently to avoid any discrepancies. One common method is to use PHP's `date()` function to format timestamps before inserting them into the database or comparing them in queries. Another approach is to use MySQL's `NOW()` function to insert the current timestamp directly into the database. Additionally, converting timestamps between PHP and MySQL formats using functions like `strtotime()` and `date()` can help maintain consistency.

// Example of inserting a formatted timestamp into MySQL using PHP
$timestamp = date('Y-m-d H:i:s');
$query = "INSERT INTO table_name (timestamp_column) VALUES ('$timestamp')";
$result = mysqli_query($connection, $query);

// Example of retrieving and comparing timestamps in MySQL query using PHP
$query = "SELECT * FROM table_name WHERE timestamp_column > DATE_SUB(NOW(), INTERVAL 1 DAY)";
$result = mysqli_query($connection, $query);