Posting from the web interface did get echoed to my inbox. So whatever is
wrong is on the e-mail reply side.
Here is my original reply. Hopefully we don't get a duplicate whenever Google
fixes whatever is wrong with the e-mail interface to the Group. :-/
FWD:
Hey, Robin,
I don't know the weewx way, but here is a sql way that may lead some smart
person to a better solution. :-/
I used the system date command up front to get the month-day, which is to avoid
asking SQLite to do that computation for every row within the query.
$ today=$(date +%\m-%\d); sqlite3 -header /var/lib/weewx/weewx.sdb "select
date(dateTime, 'unixepoch', 'localtime') as day, min, max from
archive_day_outTemp where strftime('%m-%d', day)='$today' group by day;"
day|min|max
2017-05-11|46.9|70.0
2018-05-11|43.5|54.9
2019-05-11|39.02|52.7
Oh, and in case outTemp is not the name of your sensor per archive_day_outTemp,
above, you can glean the table you need from here:
$ sqlite3 /var/lib/weewx/weewx.sdb ".tables"
And of course to see the column names available, it's:
$ sqlite3 /var/lib/weewx/weewx.sdb ".schema archive_day_outTemp"
CREATE TABLE archive_day_outTemp (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY,
min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER,
wsum REAL, sumtime INTEGER);
Or the more human readable way:
$ sqlite3 -header /var/lib/weewx/weewx.sdb "select * from archive_day_outTemp
limit 1;"
dateTime|min|mintime|max|maxtime|sum|count|wsum|sumtime
1325394000|||||0.0|0|0.0|0
HTH. =D
Regards,
\Leon
--
Leon Shaner :: Dearborn, Michigan (iPad Pro)
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/b9d8a97c-17db-4a7b-80aa-7d3354e97485%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
