Calculating time difference between 2 dates in minutes

select * from MyTab T whereTIMESTAMPDIFF(MINUTE,T.runTime,NOW()) > 20

mysql sql timestamp

ROUND(time_to_sec((TIMEDIFF(NOW(), "2015-06-10 20:15:00"))) / 60);

mysql sql timestamp

I am using below code for today and database date.

TIMESTAMPDIFF(MINUTE,T.runTime,NOW()) > 20

According to the documentation, the first argument can be any of the following:

MICROSECONDSECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

CodeHunter