Calculating a Difference between Two Dates in Minutes.

If we want to find out the difference in terms on minutes,then just divide the below result by 60.

SELECT (UNIX_TIMESTAMP(dt2) - UNIX_TIMESTAMP(dt1))/60 from table_name;