Check MySQL Comparison Time with DATETIME Printing

Question

I want to check if it has passed an hour since the last mark datetimein MySQL. How to do it using PHP?

Answer 1

The cleanest way to do this is in MySQL using DATE_SUB (or DATE_ADD depending on your goals). For instance:

SELECT DATE_SUB(NOW(), INTERVAL 1 HOUR)

Similarly, you can replace “1 HOUR” with other things, such as “1 DAY” or “1 MINUTE,” etc. I always prefer to make date comparisons at the database level, since presumably the dates are stored in a common format and clockwise offset.

Answer 2

you could and probably should do it all in mysql instead

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

datetime .

Answer 3

This link explains date_diff for PHP> = 5.3 and some solutions for the older version.

Answer 4

$db_time = strtotime($row->timestamp_col);
$age = 60 * 60;
if ($db_time < (time() - $age)) {
    doSomething();
}

This is not necessarily broken so you can see how it works.

Answer 5

$now = time();

$dbDate = strtotime($row['datetime']);

if ($now > $dbDate + 3600) {
   // yes
}

Answer 6

You put a check in the request. Then you can use MySQL date comparison, and PHP does not need to know or care.