Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Broblem getting Avrage of date parameter
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
I know it long but it's working prefectly........ :-) Received on Sun Oct 01 2006 - 02:33:14 CDT