db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com>
Subject Re: Sum of time
Date Tue, 17 Jul 2007 23:40:01 GMT
On Tuesday 17 July 2007 18:03:43 Dmitri Pissarenko wrote:
> 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.

Out of curiosity, what happens if you add this int to the Time 00:00:00?

Daniel


-- 
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia    Ph: +61 2 9280 0699
Web: http://nuix.com/                               Fax: +61 2 9212 6902

Mime
View raw message