TIMEDIFF(t,s) 

TIMEDIFF(t,s) is a time function that calculates the time value between a start and end time.

t and s: time or timestamp expression
Both arguments must have the same data type, i.e. they must be either a
time value or a timestamp value.

 

Result of the TIMEDIFF(t,s) function

Positive difference between t and s

Time value

t or s are timestamp values for alphanumeric values that match the current timestamp format.

The dates contained in the timestamp value are used to calculate TIMEDIFF(t,s).

Difference of more than 9999 hours

Number of hours modulo 10000

t or s is NULL value

NULL value (see data type)