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