On Wednesday, March 8, 2017 at 2:24:30 PM UTC-8, vince wrote: > > On Wednesday, March 8, 2017 at 12:22:17 PM UTC-8, Robert Mantel wrote: >> >> I forgot to edit the search list extensions and append the last rain >> tags, works now, but in the graph I'm seeing the last rain showing NaN >> undefined at 07:56. At first I thought it's because there wasn't any rain >> today, how far back in time does this function look for the last rain? Or >> is it simply the current day? >> > > Should be all your data, if you look at the extension python code you'll > see the sqlite queries in there. > > This gives you the date+time of the day with the last rain: > > echo "SELECT MAX(dateTime) FROM archive_day_rain WHERE sum > 0;" | > sqlite3 weewx.sdb > > > Then run "date -d @NNNNNNNN" using that output to get something more > human friendly for the date+time of the 'beginning' of which day had the > most recent rain. There's code later on in the python stuff that figures > out the offset from then to 'now'. > > We had rain today, so my output here looks like: > > (oops)
root@debian:/home/weewx/archive# echo "SELECT MAX(dateTime) FROM archive_day_rain WHERE sum > 0;" | sqlite3 weewx.sdb 1488960000 root@debian:/home/weewx/archive# date -d @1488960000 Wed Mar 8 00:00:00 PST 2017 > > -- 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.
