Avg Date Diff?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

naomimsm@gmail.com - 29 Jun 2006 18:49 GMT

Has anyone had any luck getting an Avg on Date Diff? Here's what I'm
trying to do:

Figure out the average time it takes from ringtime (datetime) to
starttime(datetime).

Any ideas?

Reply to this Message

Matt - 30 Jun 2006 02:39 GMT

Does this work for you?
SELECT SUM(DATEDIFF(SECOND, RingTime, StartTime))/COUNT(*) FROM myTable

> Has anyone had any luck getting an Avg on Date Diff? Here's what I'm
> trying to do:
[quoted text clipped - 3 lines]
>
> Any ideas?

Reply to this Message

naomimsm@gmail.com - 30 Jun 2006 14:49 GMT

Sorry, I should have been clearer: I'm trying to define a formula in
Report Builder and I can't get it to give me an average--very
frustrating! Thanks!

> Does this work for you?
> SELECT SUM(DATEDIFF(SECOND, RingTime, StartTime))/COUNT(*) FROM myTable
[quoted text clipped - 6 lines]
> >
> > Any ideas?

Reply to this Message