>HI do u have any scripts that get the diffence of Datatime in hrs, Min, Seconds .

Assuming that the difference is less than 24 hours

DECLARE @dt1 datetime, @dt2 datetime
SET @dt1 = '2005/07/01 10:45:15'
SET @dt2 = '2005/07/01 17:23:37'
SELECT CONVERT(varchar(20), CAST(@dt2 - @dt1 AS datetime), 108)