Re: Broblem getting Avrage of date parameter

From: Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de>
Date: Thu, 28 Sep 2006 12:05:40 +0200
Message-ID: <4o1l3jFcfu46U1@news.dfncis.de>

Rafael Amar wrote:
> Hello All,
> I have a problem i'll be more then glad if someone can halp me.
> I have a column that containes DATE example: 30/12/1899 00:00:23.
> I need to get the avg run time for the spesific column.
>
> Example:
> I have 2 row in the column that 30/12/1899 00:00:23 and 30/12/1899
> 00:00:25
>
> I need to get the answer 30/12/1899 00:00:24
>
> Thanks,
> Rafael
>

Hi Rafael,

I think this should work:

SELECT
AVG(DATE_ROW-TO_DATE('1900','YYYY'))+TO_DATE('1900','YYYY') AVG_DATE_ROW FROM MY_TABLE Björn Received on Thu Sep 28 2006 - 05:05:40 CDT