Re: need avg(timestamp1 - timestamp2), get type error

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 16 Jan 2004 03:05:04 GMT
Message-ID: <AxINb.77513$xy6.135481@attbi_s02>

"Ariant" <ariant23_at_earthlink.net> wrote in message news:7a108ec3.0401151130.25b50118_at_posting.google.com...
> Hi -
>
> I'm trying to query my database to find the min, max and average times
> (in seconds, or minutes, or something) between two timestamps. I've
> tried using:
>
> Select avg(timestamp1 - timestamp2) from table;
>
> I get an error saying that avg() expects a number, not an interval.
> Is there a way (in a SQL stmt) to convert timestamps (or their
> intervals, if they're different) so that I can run the avg, min, and
> max functions?
>
> I know that I could easily do this in C++ or Java, but I'm hoping to
> do all of my calculations in SQL statements, since they will be faster
> than in Java.
>
> Thanks!
> Ariant

Try the documentation. If you subtract 1 o'clock from 2 o"clock what do you get? An interval of an hour!
Jim Received on Thu Jan 15 2004 - 21:05:04 CST