MySQL TIMEDIFF Function

Example

Return the difference between two time expressions:

SELECT TIMEDIFF("13:10:11", "13:10:10");

Definition and Usage

The TIMEDIFF() function returns the difference between two time/datetime expressions.

Note: time1 and time2 should be in the same format, and the calculation is time1time2.

Syntax

TIMEDIFF(time1, time2)

Continue reading MySQL TIMEDIFF Function