OK, there's the problem. For whatever reason, the column `maxtime` in the daily summaries for 5-Apr-2007 has the high temperature for the next day, 6-Apr-2007.
This pattern seems to occur sporadically for many other years. Do you suppose that your computer was running UTC when the daily summaries were rebuilt? Was your weather station vacationing in Miami in 2007? A high of 79 for April has got to be very unusual for Seattle! :-) -tk -tk On Sun, Apr 5, 2020 at 3:23 PM Vince Skahan <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-development/23c39c35-2257-4cbc-a78b-5462c73abc9c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zEDZZQ%3D8y2Qrztx%2BT%2BVH2mmWZBOOFVDYcNSa%2BThMRtVSZw%40mail.gmail.com.
