Ubuntu – HOw to calculate the time difference in Minutes for a database?
Following 2 queries should calculate the difference in minutes, but one is correct and the other gives a wrong result. Is this a bug, or my bug? SELECT FLOOR(TIME_TO_SEC(TIMEDIFF(NOW(),start_time))/60) AS minutes = 23 (correct) SELECT TIME_TO_SEC(TIMEDIFF(NOW(),start_time)) DIV 60 AS minutes…