Re: Broblem getting Avrage of date parameter

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 28 Sep 2006 14:53:30 +0200
Message-ID: <4o1uuaFckr8mU1@individual.net>

On 28.09.2006 10:24, 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

I read your question that you want the average of two successive records, i.e. values in the middle. Is that true? If so there /might/ be a solution with analytical functions but I am not too versed and also to lazy to come up with an answer at the moment.

But I agree to others you should try to be a bit more specific with your question.

Regards

robert Received on Thu Sep 28 2006 - 07:53:30 CDT