TIMEDIFF(t,s) 
TIMEDIFF(t,s) is a time function that calculates the time value between a start and end time.
t and s values: When used in a function, the expressions t and s must supply a time value, a time stamp value or an alphanumeric value that matches the current time or time stamp format. The arguments must have the same data type, in other words, be either a time value or a time stamp value.
t, s |
Result of the TIMEDIFF(t,s) Function |
|---|---|
Positive difference between t and s |
Time value |
t or s are time stamp values for alphanumeric values that match the current time stamp format |
Dates in the time stamp value are used to calculate TIMEDIFF(t,s) |
Difference of more than 9999 hours |
Number of hours modulo 10000 |
t or s is a NULL value |
NULL value |