Hello! One obvious way is to use this:
SELECT PLACE, SUM(SECOND(DURATION) + MINUTE(DURATION)*60 + HOUR(DURATION)*60*60) FROM MyTable GROUP BY PLACE But I still need to convert int to time. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko http://dapissarenko.blogspot.com/
