| Subject | Re: i want to this ; select avg(datefield) from ... but what? |
|---|---|
| Author | Anderson Farias |
| Post date | 2008-05-21T10:53:51Z |
Hi,
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] ??
Regards,
Anderson Farias
> But it should, don't you agree?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] ??
Regards,
Anderson Farias