Posts by Andreas Cauê • 51 points

• 5

  votes

  5

  answers

  64148

  views

  A: Difference between two dates in days, hours, minutes and seconds

  This code is wrong in the calculation of the time difference. The time difference should be like this: + RIGHT('00' + CONVERT(VARCHAR, DATEDIFF(MINUTE, @antes, @depois) / 60), 2) + ':' For in the…

  sql sql-server datetime

  answered 9 years, 6 months ago Andreas Cauê 51