A simple query that computes time difference between two dates and displays the result in “hh:mm” format.

-- 2008-08-10 00:00:04 < Start_Time
-- 2008-08-10 08:32:17 < End_Time
-- 8:32 << Output (HHMM_Duration)

SELECT Start_Time, End_Time,
CONVERT(VARCHAR, DATEDIFF(hour, Start_Time, End_Time)) + ':' + CONVERT(VARCHAR, DATEDIFF(minute, Start_Time, End_Time)%60) as HHMM_Duration
FROM Events

*The above query was executed on Microsoft SQL Server 2000.

Rate this topic:

(No Ratings Yet)

 Loading ...