Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DateDiff and then SUM 1

Status
Not open for further replies.
Cpreston

Cpreston

MIS
Mar 4, 2015
987
GB
Hi

I have used the below code to calculate the difference between 2 datetime fields. The result is in seconds but I would like it to display hours and minutes and seconds if possible. I have tried SUM and also converet with just Time instead of datetime. Any ideas please

DATEDIFF(MINUTE,CONVERT(DATETIME,dbo.WTTReportHeader.StartTime,101),CONVERT(DATETIME,dbo.WTTReportHeader.EndTime,101)) as Timediff



Capture_ybygoz.jpg
 
Sort by date Sort by votes
As in my reply to your previous question:
Code: 
SELECT LEFT(CONVERT(TIME, DATEADD(ss, DATEDIFF(ss,dbo.WTTReportHeader.StartTime, dbo.WTTReportHeader.EndTime),0)),8) 
FROM YourTable

Borislav Borissov
VFP9 SP2, SQL Server
 
Upvote 0 Downvote
Hi bborissov
Thanks for the post, I was trying to use your code from the previous post but could not quite get it right with the convert and then the datediff.
Your line of code worked first time so thank you for your help, really appreciated.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
602
Chris Miller
Chris Miller
msi30502
  • Locked
  • Question
Numbering Group Headers, then sum
Replies
16
Views
556
Andrzejek
Andrzejek
agorjest1
  • Locked
  • Question
SQL Conditional Sum
Replies
0
Views
279
agorjest1
agorjest1
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
623
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
323
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top