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, 2414🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...