Hi Richard,
That gave me 10 hour intervals not 10 minute. Which is the part that
controls the frequency?
Thanks,
Andrew S.
-----Original Message-----
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: Wednesday, November 18, 2015 8:41 AM
To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org>
Subject: Re: [sqlite] 10 minute Avg
On 11/18/15, Andrew Stewart <AStewart at arguscontrols.com> wrote:
> Hi,
> I am trying to generate 10 minute average data for a
> day from a data set. Table is created by the following:
>
> CREATE TABLE dataStreamRecord (fwParameterID INTEGER NOT NULL,
> dateTime DATETIME NOT NULL, data INTEGER NOT NULL);
>
> Sample Data
> fwParameterID,dateTime,data
> 1074,2015-11-17 00:00:01,8192
> 1074,2015-11-17 00:33:18,0
>
> Any assistance in generating a query to do 10 minute averages for
> 'data' on November 17 for fwParameterID 1074 would be appreciated.
>
Maybe this:
SELECT substr(dateTime,1,12)||'0:00:00', avg(date)
FROM dataStreamRecord
WHERE fwParameterID=1074
AND dateTime BETWEEN '2015-11-17' AND '2015-11-18'
GROUP BY substr(dateTime,1,12)
ORDER BY 1;
--
D. Richard Hipp
drh at sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Notice: This electronic transmission contains confidential information,
intended only for the person(s) named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or any other use of this email is strictly prohibited. If you have received
this transmission by error, please notify us immediately by return email and
destroy the original transmission immediately and all copies thereof.
