Ver Mensaje Individual
  #7  
Antiguo 11-09-2017
Avatar de ecfisa
ecfisa ecfisa is offline
Moderador
 
Registrado: dic 2005
Ubicación: Tres Arroyos, Argentina
Posts: 10.508
Reputación: 36
ecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to behold
Hola.
Cita:
Empezado por solilopi Ver Mensaje
..., ¿Se podría devolver en formato hh:mm:ss?
Código SQL [-]
SELECT
  (DATEDIFF(SECOND, CAST(T1 AS TIME), CAST(T2 AS TIME)) / 3600) || ':' ||
  (MOD(DATEDIFF(SECOND, CAST(T1 AS TIME), CAST(T2 AS TIME)), 3600) / 60) || ':' ||
   MOD(DATEDIFF(SECOND, CAST(T1 AS TIME), CAST(T2 AS TIME)), 60)
FROM LATABLA

Saludos
__________________
Daniel Didriksen

Guía de estilo - Uso de las etiquetas - La otra guía de estilo ....
Responder Con Cita