Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Group-function SUM on time (date-field)

Group-function SUM on time (date-field)

From: Thomas Stuefer <stuefer_at_halli-data.at>
Date: Wed, 24 Apr 2002 17:22:53 +0200
Message-ID: <jcvx8.21$Be1.98401@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:22:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US