Re: Summary with Group-by function on time (date-field)

From: Peter Laursen <pl_at_mail1.remove.this.stofanet.dk>
Date: Wed, 24 Apr 2002 20:18:53 +0200
Message-ID: <3cc6f75b$0$3776$ba624c82@nntp01.dk.telia.net>

>
> select user, to_char(sum(to_number(to_char(duration,'HH24'))) +
> trunc(sum(to_number(to_char(duration,'MI')))/60))
>

||':'||to_char(mod(sum(to_number(to_char(duration,'MI'))),60))||':00'
> as duration
> from test
> group by user;
>
> It takes a while to compute it...
> I am also very curious how many better/easier solutions are out
there.

How about

select user, sum(d - trunc(d)) duration_as_number_of_days from test
group by user

and format the output as you wish

Peter Laursen Received on Wed Apr 24 2002 - 13:18:53 CDT