Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: GROUP BY DAY.... problem.

Re: GROUP BY DAY.... problem.

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sun, 27 Feb 2005 20:47:53 +0100
Message-ID: <6v8421pf6md740t7n42rggpf16m0b040ao@4ax.com>


On 26 Feb 2005 23:33:10 -0800, "rishib4u_at_gmail.com" <rishib4u_at_gmail.com> wrote:

>hi everyone,
>i have a query that needs to calculate the AVG of records taken at 15
>minutes interval 24/7 grouped by day for a date range. As per the
>requirements the AVG needs to consider the following guidelines -
>say the the time for which the data has to be avg'd up is 7:00 am to
>8:00 am then the AVG would be for all data recorded at (7:15, 7:30,
>7:45 & 8:00) excluding the first record at 7:00 am i.e. > 7:00 AM AND
><= 8:00 AM.
>NOW the problem is that when i GROUP BY date the AVG function
>calculates the average of all records for that day including the record
>at 0:00 HRS and excluding the record at 24:00 HRS whence it should be
>the exact opposite as per the guidelines.
>Can anyone please suggest a solution?
>thankyou,
>rishi.

subtract 5 minutes from a date field before comparing it with the interval.

Jaap. Received on Sun Feb 27 2005 - 13:47:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US