Subject | Re: [firebird-support] Re: i want to this ; select avg(datefield) from ... but what? |
---|---|
Author | Kjell Rilbe |
Post date | 2008-05-21T11:03:01Z |
Anderson Farias wrote:
scale, whereas letters are truly discrete and not possible to plot as
points on any continuous scale at all. So, an average date would be the
date where the average point in time falls. You should probably
calculate each date as meaning "noon on that day" for such an
interpretation.
I agree that it's a bit muddy, but it's not unthinkable, is it?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> > But it should, don't you agree?But that's not fair, because dates are just points on a continuous time
>
> IMHO, the fact that dates are internaly represented by a number does
> not make them a number. Detes are discrete (distinct) elements, I can't
> see how could one take a average from that.
>
> Lets say you have this set:
> [A, B, A, A, C, B] ... then, what's the avg ??
>
> That's the same with dates, what whould be the avg. for
> [mar-08-01, jan-08-31, may-07-29] ??
scale, whereas letters are truly discrete and not possible to plot as
points on any continuous scale at all. So, an average date would be the
date where the average point in time falls. You should probably
calculate each date as meaning "noon on that day" for such an
interpretation.
I agree that it's a bit muddy, but it's not unthinkable, is it?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64