On Sunday, April 5, 2020 at 3:20:17 PM UTC-7, Tom Keffer wrote:
>
> OK, that matches what the historical extension is giving.
>
> A few more selects to try
>
>
>
root@debian:/home/weewx/archive# sqlite3 weewx.sdb
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select date(dateTime,'unixepoch','localtime'),
datetime(`maxtime`,'unixepoch','localtime'),`max` from archive_day_outTemp
where strftime("%m-%d", dateTime,'unixepoch','localtime')='04-05';
2007-04-05|2007-04-06 16:34:00|79.0
2008-04-05|2008-04-06 11:29:00|51.3
2009-04-05|2009-04-06 17:00:00|71.199997
2010-04-05|2010-04-06 14:05:00|52.400002
2011-04-05|2011-04-05 17:50:00|47.7
2012-04-05|2012-04-06 16:20:00|55.0
2013-04-05|2013-04-05 17:05:00|53.7
2014-04-05|2014-04-06 16:45:00|58.4
2015-04-05|2015-04-06 16:50:00|57.6
2016-04-05|2016-04-06 16:10:00|65.9
2017-04-05|2017-04-06 16:25:00|59.6
2018-04-05|2018-04-06 16:25:00|68.3
2019-04-05|2019-04-06 16:15:00|55.5
2020-04-05|2020-04-05 12:22:41|56.6
sqlite> select datetime(dateTime,'unixepoch','localtime'),outTemp from
archive where dateTime >1175756400 and dateTime<=1175842800 order by
outTemp desc limit 1;
2007-04-05 17:14:00|72.5
sqlite> select datetime(dateTime,'unixepoch','localtime'),outTemp from
archive where dateTime >1175842800 and dateTime<=1175929200 order by
outTemp desc limit 1;
2007-04-06 16:34:00|79.0
sqlite>
--
You received this message because you are subscribed to the Google Groups
"weewx-development" 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-development/23c39c35-2257-4cbc-a78b-5462c73abc9c%40googlegroups.com.
