Posts by Paulo Henrique • 37 points

• 1

  votes

  2

  answers

  420

  views

  Q: The Datediff function resulted in an Sql Server overflow

  I have the following appointment: SELECT ISNULL(MAX(CONVERT(TIME(0), DATEADD(SECOND, DATEDIFF(SS, [INICOLIGACAO],[FINALLIGACAO]), 0))),'') AS [DURACAO_CHAMADA] WHERE CONVERT(DATE,[DIA]) =…

  sql sql-server

  asked 5 years ago Paulo Henrique 37