Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Calculate the Difference between Two Time Values
How To Calculate the Difference between Two Time Values? - MySQL FAQs - Introduction to SQL Date and Time Handling
✍: 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
2007-05-11, 4723👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - What is the difference between System exceptions and Application exceptio...
What is the method to customize columns in DataGrid? Use the template column.
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
How To Enter a New Row into a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Dev...
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...