I want with datediff a result like 26:23 - HOW ??

• Jan Löfgren

  SSC Enthusiast

  Points: 197

  More actions

  May 11, 2004 at 12:02 am

  #111230

  Is there someone who can help me because i'm rather new to SQL (worked always in MS ACCESS) but what I want is the difference between 2 datetime fields expressed as HOURS:MINUTES (the hours can go over 24) and where I can do calculations on (Sum, average, etc). With DATEDIFF i get only an Integer in 1 expression (days or hour or minute, etc)

  Example : 2004-05-11 00:00:00 - 2004-05-09 11:45:00 = 36:15

  Thanks,

  Jan

   

• george k abaraham

  SSC Journeyman

  Points: 97

  More actions

  May 11, 2004 at 1:44 am

  #505915

  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))