Monthly Archive: January 2008

Jan 13 2008

T-SQL: Calculate Hours, Mins and Secs from StartTime and EndTime

Categories:

Programming, SQL

by Wayne

January 13, 2008

select   sum(TotalSeconds) / 3600 as Hours,   (sum(TotalSeconds) % 3600) / 60 as Minutes,   sum(TotalSeconds) % 60 as Secondsfrom(select ArrivalTime, DepartureTime, DateDiff(second, ArrivalTime, DepartureTime) as TotalSeconds from SSRwhere CustomerID = 10) xThanks to this site for the heads up.

This post has no tag

Permanent link to this article: http://ramblinggeek.co.uk/2008/01/t-sql-calculate-hours-mins-and-secs-from-starttime-and-endtime/