Re: SQL Question: Averages of intervals.

On Sat, January 24, 2009 8:05 pm, Jasen Betts wrote:

> 10 minutes is 600 seconds
>
> SELECT AVG("IOW"),AVG("SYS"),AVG("USR"),MIN("Time"),"MachineName"
> FROM "LoadTable"
> WHERE "Date"='today'::date
> GROUP BY FLOOR( EXTRACT(EPOCH FROM "Time") / 600 ),"MachineName";

This worked perfectly. Thank you.

Daniel T. Staal