Re: Grouping Results In 5 Minute Increments

Thanks for all of your suggestions! We put our heads together and came up with this. It's fairly simple, and you can adjust the fraction to group by other subcomponents of a day....

• 1/288 is the fraction of a day represented by 5 minutes minInterval := 1/288;

SELECT (((floor((tmstmp - trunc(tmstmp,
'DD'))/minInterval))*minInterval)+trunc(tmstmp, 'DD')), AVG(value)
from table
GROUP BY (((floor((tmstmp - trunc(tmstmp,
'DD'))/minInterval))*minInterval)+trunc(tmstmp, 'DD'));

Cheers!