time left mysql query

The solution for this is noted below

time left mysql query

Solution

SELECT ((UNIX_TIMESTAMP(field_with_date_in_table) - UNIX_TIMESTAMP(NOW()))/3600) AS hoursleft

Try other methods by searching on the site. That is if this doesn’t work