SQL Server 2000

I have 2 date columns formatted as yyyy-mm-dd hh:mm:sec.  What is the best
way to calculate the difference between the 2 columns and have the result
fomatted in hh:mm - even if the difference is greater than 24 hours?

Thanks in advance.

Hi
CREATE FUNCTION dbo.presentDiffInHHMMSS
(
 @date1 DATETIME,
 @date2 DATETIME
)
RETURNS VARCHAR(32)
AS
BEGIN
 DECLARE @sD INT, @sR INT, @mD INT, @mR INT, @hR INT
 SET @sD = DATEDIFF(SECOND, @date1, @date2)
 SET @sR = @sD % 60
 SET @mD = (@sD - @sR) / 60
 SET @mR = @mD % 60
 SET @hR = (@mD - @mR) / 60

 RETURN CONVERT(VARCHAR, @hR)
 +':'+RIGHT('00'+CONVERT(VARCHAR, @mR), 2)
 +':'+RIGHT('00'+CONVERT(VARCHAR, @sR), 2)
END

DECLARE @dt DATETIME
SET @dt = '2007-05-30 17:04:32'
PRINT dbo.presentDiffInHHMMSS(@dt, GETDATE())

DROP  FUNCTION dbo.presentDiffInHHMMSS

news:A4B82F0A-4CEC-4642-98F3-D02BF060503F@microsoft.com...