In MYSQL, I know I can return a difference between dates using the DATE_DIFF
function.
example:
SELECT * FROM table WHERE DATEDIFF(NOW(), created) <= ?
However, I need to return the difference in day converted to hours in this DATEDIFF
. Well, I need to compare this difference to see if a certain deadline has already expired (and this deadline is hours, not days).
How can I get the value in hours of a DATEDIFF
in MYSQL?