DECLARE @fecha1 DATETIME

DECLARE @fecha2 DATETIME

DECLARE @fecha3 DATETIME

DECLARE @fecha4 DATETIME

​

​

SET @fecha1 = '20170419 01:00:00'

SET @fecha2 = '20170419 06:00:00'

SET @fecha3 = '20170418 22:00:00'

SET @fecha4 = '20170419 01:00:00'

​

SELECT DATEDIFF(mi, @fecha1, @fecha2) AS 'MinutosTranscurridos'

​

SELECT DATEDIFF(mi, @fecha3, @fecha4) AS 'MinutosTranscurridos'

​

--Manejando los negativos:

​

SELECT ABS(DATEDIFF(mi, @fecha1, @fecha2)) AS 'MinutosTranscurridos'

​

SELECT ABS(DATEDIFF(mi, @fecha3, @fecha4)) AS 'MinutosTranscurridos'