how to SUM over TIME col (without TIME_TO_SEC)?

[Sebastian Mendel]

Hi,

how can i get the SUM of a TIME field without using TIME_TO_SEC()?

example:

SELECT
    SUM(`my_time`)
FROM
    `table`
GROUP BY
    `id`

returns: 765

some completely wrong result, not formated in as TIME


SELECT
    SEC_TO_TIME(SUM(TIME_TO_SEC(`my_time`)))
FROM
    `table`
GROUP BY
    `id`

returns: 838:59:59

correct result in TIME format, but with rounding errors

-- 
Sebastian

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]