Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DAY TO SECOND SUM extract

515325Aug 28 2006 — edited Aug 28 2006
HI To all,

i'm trying to sum the total of the working hour for an entire week.
I've all (the interval monday / friday as well).

What i don't fully understand is how does extract works.
My prog stores the worked time in a col as interval day to second.

Provide me an example to do the sum in format hh:mm.
Let's only say that i've a table as follows:

COUNTER NOT NULL NUMBER
UTENTE VARCHAR2(30)
ORAINIZIOMATTINA TIMESTAMP(6)
ORAFINEMATTINA TIMESTAMP(6)
ORAFINEPOMERIGGIO TIMESTAMP(6)
TOTALE INTERVAL DAY(5) TO SECOND(6)
D DATE

I want only to output the sum the field TOTALE as hh:mm (togeter or separate as i can use 2 different field.

thanks a lot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2006
Added on Aug 28 2006
4 comments
1,115 views