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

From: Thomas Stuefer <stuefer_at_halli-data.at>
Date: Wed, 24 Apr 2002 17:16:01 +0200
Message-ID: <T5vx8.20$Ed1.57401@news.salzburg-online.at>

Hi !

I use Oracle 8.1.7.2.7 and have a simple table:

user                    VARCHAR2(30)
duration                DATE

The data in this table looks like:

USER                       DURATION


------------------------------------------------

SCOTT                      01.04.2002 01:30:00
ADAMS                      01.03.2002 00:45:00
MILLER                     01.04.2002 01:35:00
SCOTT                      01.04.2002 00:50:00
SCOTT                      01.02.2002 00:30:00
MILLER                     01.03.2002 00:10:00
ADAMS                      01.04.2002 00:20:00
MILLER                     01.02.2002 00:30:00

How can I get the group-summary of duration on every user:

USER                       SUM_DURATION


------------------------------------------------

ADAMS                      01:05:00
MILLER                     02:15:00
SCOTT                      02:50:00

Remark: The date in the field "duration" is not important and can be ignored.

Many thanks for your help !

Thomas Received on Wed Apr 24 2002 - 10:16:01 CDT