php-mysqlHow to compare datetime in MySQL and PHP?

MySQL and PHP both have built-in functions to compare datetime values.

In MySQL, the DATE_SUB() function can be used to compare two datetime values. It returns the difference between two datetime values in seconds.

SELECT DATE_SUB(datetime1, datetime2)

Output example

-7200

In PHP, the strtotime() function can be used to compare two datetime values. It returns the difference between two datetime values in seconds.

$difference = strtotime($datetime1) - strtotime($datetime2);

Output example

-7200

Code explanation

• DATE_SUB(): MySQL function to compare two datetime values and return the difference in seconds
• strtotime(): PHP function to compare two datetime values and return the difference in seconds

Helpful links

• MySQL DATE_SUB() Function
• PHP strtotime() Function

Edit this code on GitHub