MySQLTIMEDIFF() Function
Example
Return the difference between two time expressions:
SELECT TIMEDIFF("13:10:11", "13:10:10");
Try it Yourself »Definition and Usage
The TIMEDIFF() function returns the difference between two time/datetime expressions.
Note:time1 andtime2 should be in the same format, and the calculation istime1 -time2.
Syntax
TIMEDIFF(time1,time2)
Parameter Values
| Parameter | Description |
|---|---|
| time1 | Required. A time value |
| time2 | Required. Another time value |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the difference between two datetime expressions:
SELECT TIMEDIFF("2017-06-25 13:10:11", "2017-06-15 13:10:10");
Try it Yourself »
