How can we calculate the difference between two time values in MySQL?

With the help of TIMEDIFF() MySQL function the difference between two-time values can be calculated.

Example

mysql> Select TIMEDIFF('04:05:45','03:05:45') AS ‘Difference in Time’;
+---------------------------------+
| Difference in Time              |
+---------------------------------+
| 01:00:00                        |
+---------------------------------+
1 row in set (0.00 sec)

Abhinaya

Published on 19-Feb-2018 11:15:45

• Related Questions & Answers
• C Program to calculate the difference between two time periods
• How to calculate the difference between time in different MySQL columns?
• C++ Program to Calculate Difference Between Two Time Period
• How to calculate the difference between two dates in JavaScript?
• Find the difference between two datetime values with MySQL?
• Get the time difference between values in different columns with MySQL
• How can we calculate the Date in MySQL using functions?
• How can I calculate full 24hour days between two specified dates in MySQL?
• With the help of function, how can we return the difference in Year, Month and Days between two date values?
• How can we offload the time/date handling in MySQL?
• How can we convert TIME and DATETIME values to numeric form in MySQL?
• How can we create MySQL stored procedure to calculate the factorial?
• How can we combine the values of two or more columns of MySQL table?
• Difference between two given time periods in C++
• How to get time difference between two timestamps in seconds?