Need dates difference in hh:mm:ss

Question

I have two columns in my table named as "start date" and "end date". I need difference of two tables and result as "completion time" in hh:mm:ss. Please help

Please visit here and updated your question : http://stackoverflow.com/help/how-to-ask — sagi, Feb 14 '16 at 14:43
What DBMS? Update issue and tag with appropriate DBMS, as solution depends on DBMS type and what column types you're using. — DBug, Feb 14 '16 at 14:44

score 0 · Answer 1 · edited May 23 '17 at 11:45

0

Possible duplicate of several questions. Listed a couple below,

SQL time difference between two dates result in hh:mm:ss

Calculate business hours between two dates

edited May 23 '17 at 11:45

Community

1
1

answered Feb 14 '16 at 14:44

Chendur

1,099
1
11
23

Need dates difference in hh:mm:ss

1 Answers1