select * from archive where (dateTime >= 1574765820) and (dateTime <= 1574766845);
will tell you what is in the table between those values and if it is the correct range then set rainRate and rain to 0 with update archive set rainRate = 0, rain = 0 where (dateTime >= 1574765820) and (dateTime <= 1574766845); On Tuesday, 26 November 2019 21:44:11 UTC+2, Chad Hutchins wrote: > > Hello! > > Using sqlite3 db for a Davis Vantage Vue station on a Raspberry Pi 3. > > I need to zero (0.00) the rain rate and rain between two time ranges. I > think the data is between the following unix timestamps (1574765820 > 1574766845) but that might not be what is exactly in the archive table. > > How do I go about finding that data so that I can run the commands listed > here for changing the data (except I would set to 0 instead of null) > https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data > > Thanks, > Chad > -- 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/a002685f-9474-4ab2-b323-1f228b0e6cf9%40googlegroups.com.
