mysql: somma datetime

[alecsss]

Soluzione:

SELECT SEC_TO_TIME(SUM(TIME_TO_SEC( TOT ))) AS Ore
FROM (

SELECT TIMEDIFF( date2, date1 ) AS TOT
FROM testdate
WHERE idOI = '1'
) AS miatabella

Grazie a tutti