Is it really that stupid? The original question was:
<<we try to emulate the AVG function for use with type DATE. How can
we convert DATE or TIMESTAMP to milliseconds? Or how can we get the
average of DATEs directly??>>
You jump to averaging of DATE, which I agree does not make sense. But
the original question indicates that the user wants some sort of
midpoint (mean, median, mode) in a set consisting of dates. He was
right to think about using a transform to convert the DATE matrix to
another matrix relating to the passing of time.
<<Can you divide Christmas by Ramadan and get Passover?>>
Of course not; matrix arithmetic does not allow it.
But the writer wants to know, "Given DATE(XMas), DATE(end of Ramadan),
DATE (Passover), when should I start advertising sales of gifts in
general and for various festivals in particular (I agree that that's a
lousy marketing strategy, but you get the drift.)?
SS
jc*******@earthlink.net (--CELKO--) wrote in message news:<18**************************@posting.google. com>...
we try to emulate the AVG function for use with type DATE. <<
That makes no sense. Can you divide Christmas by Ramadan and get
Passover? You can average durations with something like
AVG(finish_time - start_time); is that what you meant?