Re: Broblem getting Avrage of date parameter

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

date_1 + (date_2 - date_1)/2

That's OK for you? Received on Thu Sep 28 2006 - 06:18:11 CDT