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 -> Re: Broblem getting Avrage of date parameter

Re: Broblem getting Avrage of date parameter

From: Rafael Amar <rafiamar_at_gmail.com>
Date: 1 Oct 2006 00:33:14 -0700
Message-ID: <1159687994.623122.293640@i42g2000cwa.googlegroups.com>


Hello Guys
I Thank you all for your quick answers
It took me One hour but i did it.
the answer is :

select to_char(
  to_date(

       to_char(
       floor(avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+
           to_number (to_char(THE_COLUMN,'mi'))*60 +
           to_number (to_char(THE_COLUMN,'ss')))/3600) ||':'||
		   floor(
		   (
      avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+
           to_number (to_char(THE_COLUMN,'mi'))*60 +
           to_number (to_char(THE_COLUMN,'ss'))) -

(floor(avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+
to_number (to_char(THE_COLUMN,'mi'))*60 + to_number (to_char(THE_COLUMN,'ss')))/3600)*3600) )/ 60 ) ||':'|| (( avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+ to_number (to_char(THE_COLUMN,'mi'))*60 + to_number (to_char(THE_COLUMN,'ss'))) -
(floor(avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+
to_number (to_char(THE_COLUMN,'mi'))*60 + to_number (to_char(THE_COLUMN,'ss')))/3600)*3600) )/ 60 - floor(( avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+ to_number (to_char(THE_COLUMN,'mi'))*60 + to_number (to_char(THE_COLUMN,'ss'))) -
(floor(avg(to_number (to_char(THE_COLUMN,'hh24'))*3600+
to_number (to_char(THE_COLUMN,'mi'))*60 + to_number (to_char(THE_COLUMN,'ss')))/3600)*3600) )/ 60) )* 60 ) ,'hh24:mi:ss') ,'hh24:mi:ss')avg

from TABLE_NAME

I know it long but it's working prefectly........ :-) Received on Sun Oct 01 2006 - 02:33:14 CDT

Original text of this message

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