TimeDiff() output in Minutes?

Hello,

I have some trouble with the format TimeDiff() returns. Of course I could parse it manually but I don’t want to shift the load to the script engine if MySQL can do it in a single call.

Right now the output is something like “8015:59:00” (h:m:s ?). Is there a way to show it in minutes right away?

Regards,
Brian


mysql> SELECT TIMEDIFF('2006-12-31 23:59','2006-02-01 00:00');

+-------------------------------------------------+
| TIMEDIFF('2006-12-31 23:59','2006-02-01 00:00') |
+-------------------------------------------------+
| 8015:59:00                                      |
+-------------------------------------------------+
1 row in set (0.01 sec)

SELECT TIME_TO_SEC(TIMEDIFF('2006-12-31 23:59',
                    '2006-02-01 00:00'))/60