Hi Tom, Yep, that's it. [root@weather ~]# sqlite3 /home/weewx/archive/weewx.sdb SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select dateTime, datetime(dateTime,'unixepoch','localtime') from archive order by dateTime limit 1; 1494356520|2017-05-09 20:02:00 sqlite>
No idea how to hose that, though. Is there a good, comprehensive guide to switching to MySQL? Thank you. 2018-08-21 13:12 GMT+01:00 Thomas Keffer <[email protected]>: > Most likely, you have an archive record with an early timestamp. You can > check it with the tool sqlite3 (assuming you are using sqlite): > > $ *sqlite3 /home/weewx/archive/weewx.sdb* > *select dateTime, datetime(dateTime,'unixepoch','localtime') from archive > order by dateTime limit 1;* > > Adjust path to your sqlite database as necessary. > > -tk > > On Tue, Aug 21, 2018 at 2:56 AM Cycle London <[email protected]> > wrote: > >> Hi, >> >> I installed my Oregon Scientific weather station on 01 January this year, >> but when I click on the 'monthly summary' at the bottom of the screen, I >> see entries for months in 2017. If I click through to them, they're of >> course empty. >> >> But I'd like to remove those entries in the menu. Can someone tell me >> how to do this? >> >> Thanks. >> >> [image: Screen Shot 2018-08-21 at 10.53.49.png] >> >> >> >> >> -- >> 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]. >> For more options, visit https://groups.google.com/d/optout. >> > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
