duda sumar el total de una diferencia de minutos

[Markgus]

Iniciado por leonardo_josue

Hola Markgus:

Puedes hacerlo de dos formas:

Código MySQL:

SELECT T.*, DifUno+DifDos+DifTres total FROM
(
SELECT 
Num,
timestampdiff(Minute,'2011-05-30T10:00:00','2011-05-30T10:15:00') DifUno,
timestampdiff(Minute,'2011-05-30T15:00:00','2011-05-30T14:50:00') DifDos,
timestampdiff(Minute,'2011-05-30T18:00:00','2011-05-30T18:00:00') DifTres
FROM MiTabla where Num = 8 and campo_fecha > current_date
) T
 
SELECT 
Num,
timestampdiff(Minute,'2011-05-30T10:00:00','2011-05-30T10:15:00') DifUno,
timestampdiff(Minute,'2011-05-30T15:00:00','2011-05-30T14:50:00') DifDos,
timestampdiff(Minute,'2011-05-30T18:00:00','2011-05-30T18:00:00') DifTres,
timestampdiff(Minute,'2011-05-30T10:00:00','2011-05-30T10:15:00') +
timestampdiff(Minute,'2011-05-30T15:00:00','2011-05-30T14:50:00') +
timestampdiff(Minute,'2011-05-30T18:00:00','2011-05-30T18:00:00') total
FROM MiTabla where Num = 8 and campo_fecha > current_date
 

Haz la prueba y nos comentas.

Saludos
Leo.

:O maestro las 2 consultas funcionaron muy bien aunque tengo duda en la 1era como funciona T.* ?
aa ya es el alias de la subconsulta verdad? bueno segun por el msj que me mando el msyql browser