db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitri Pissarenko" <dmitri.pissare...@gmail.com>
Subject Re: Sum of time
Date Tue, 17 Jul 2007 08:03:43 GMT
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/

Mime
View raw message