.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

How To Calculate the Difference between Two Time Values

Q

How To Calculate the Difference between Two Time Values? - MySQL FAQs - Introduction to SQL Date and Time Handling

✍: 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

2007-05-11, 4646👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML