How to get the difference between dates and turn into hours?

Question

In MYSQL, I know I can return a difference between dates through the function DATE_DIFF.

example:

 SELECT * FROM table WHERE DATEDIFF(NOW(), created) <= ?

However, I need that in this DATEDIFF the difference in day converted to hours is returned. Because I need to compare this difference to know if a certain deadline has already expired (and that deadline is in hours, not in days).

How can I get the value in hours of one DATEDIFF in MYSQL?

Answer 1

Use the function timediff() he looks like datediff() but returns the time(hh:mm:ss) of two dates. To compare only the time, use function HOUR() thus only the time is returned, as in the third example.

Example:

SELECT * FROM table WHERE TIMEDIFF(NOW(), created) <= ?

SELECT TIMEDIFF('2016-06-16 00:00:00', '2016-06-15 13:20:51') //10:39:09

SELECT HOUR(TIMEDIFF('2016-06-16 00:00:00', '2016-06-15 13:20:51')) //10

Answer 2

A good option in this case is to use TIMESTAMPDIFF, which already gives the result to the desired extent:

  SELECT TIMESTAMPDIFF( HOUR, created, NOW() );

You can use SECONDS, or other measures in place of HOUR, depending on the need.

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