Difference in hours and minutes between two datetimes MySQL

Question

I've a query in MySQL that is returning the difference between two datetimes. The problem is that the query is giving only the difference in hours.

Example:

Datetime1 is 2015-12-16 08:00:00 and datetime2 is 2015-12-16 10:45:00

I want the difference to be returned as: 02:45:00 and not only 02:00:00

My query is:

$query1 = "SELECT X, 
                  time_format(SUM(abs(timediff(datetime2, datetime1))),'%H:%m:%s') as SUM 
           FROM table1, table2 
           WHERE table1.Y = table2.Y 
             and DATE(datetime1) >= '$datepicker' 
             AND DATE(datetime1) <= '$datepicker1' 
           GROUP BY table.Y";

Answer 1

As far as I can tell your query syntax for working out the time difference is correct except for the formatting in the time_format().

The format for minutes is %i and not %m so change to this and it should work as expected

time_format(SUM(abs(timediff(datetime2, datetime1))),'%H:%i:%s') as SUM 
                                                         ^^