Loading lesson path
Concept visual
Start at both ends
Return the difference between two time expressions: SELECT TIMEDIFF("13:10:11", "13:10:10");
Formula
The TIMEDIFF() function returns the difference between two time/datetime expressions.time1 and time2 should be in the same format, and the calculation is time1
time2.
time1, time2 )
Required. A time value time2 Required. Another time value
From MySQL 4.0
Return the difference between two datetime expressions: SELECT TIMEDIFF("2017-06-25 13:10:11", "2017-06-15 13:10:10");
❮ MySQL Functions