Collections:
Calculating the Difference between Two Time Values in MySQL
How To Calculate the Difference between Two Time Values in MySQL?
✍: FYIcenter.com
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
⇒ Presenting a Past Time in Hours, Minutes and Seconds in MySQL
⇐ Calculating the Difference between Two Dates in MySQL
2017-12-26, 2412🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...