Viewing post 1 (of 2 total)
Try this query
declare @dtdiff int
set @dtdiff = datediff(mi,'2004-05-09 11:45:00','2004-05-11 00:00:00')
select convert(varchar,@dtdiff/60)+':'+convert(varchar,@dtdiff-((@dtdiff/60)*60))
May 11, 2004 at 1:44 am
#505915