Calculating the Difference between Two Time Values in MySQL

Q

How To Calculate the Difference between Two Time Values in MySQL?

✍: FYIcenter.com

A

If you have two time values, and you want to know the time difference between them, you can use the TIMEDIFF(time1, time2) function as shown below:

SELECT TIMEDIFF(TIME('19:26:50'), TIME('09:26:50')) 
   FROM DUAL;
   10:00:00

SELECT TIMEDIFF('1997-03-01 19:26:50.000123', 
   '1997-02-28 09:26:50.000000') FROM DUAL;
   34:00:00.000123

 

⇒Introduction to Date and Time Handling in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 178👍, 0💬

General MySQL Oracle SQL Server