OK, so used epoch time to find the records I want to delete (with rain and rainRate), now do I just delete them or do they need to be replaced by null (or 0.0?). I may need a hand with the correct syntax for that please
*pi@wduino*:*~ $* echo "SELECT rainRate FROM archive WHERE (dateTime > 1617159600);" | sudo sqlite3 /var/lib/weewx/weewx.sdb 0.0419816511200587 0.0 0.0 0.0 0.0 0.0 0.0 0.0 279.980998292116 247.545269518011 19.3118544276522 13.7807155122679 5.58392519958292 0.957907401564173 4.75823850308484 5.67484207064662 0.84798164620346 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 *pi@wduino*:*~ $* On Wed, 31 Mar 2021 at 18:05, Colin Larsen <colin.lar...@gmail.com> wrote: > I'm thinking that the easiest road here is to delete (or null??) all of > todays rain data. So that would be 'rain' and 'rainRate'? > > Thanks > Colin > > On Wed, 31 Mar 2021 at 17:44, colin....@gmail.com <colin.lar...@gmail.com> > wrote: > >> It's not my week lol! >> >> Now that I've rebuilt Weewx my weather station decided to go rogue and >> tell me it rained about 500mm in the last hour. I've stopped it thinking >> it's raining but now how do I get rid of the rogue data from the database >> in Weewx? I did a search for all kinds of database issues here but my >> search fu is failing me. >> >> Cheers for any help (and yes I have no doubt it's easy!) >> >> Colin >> >> -- >> 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 weewx-user+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/ce3e4ec1-e936-487e-8df8-ebd96d376619n%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/ce3e4ec1-e936-487e-8df8-ebd96d376619n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CACjxfUt%2BC2f%3D8796Ayg43%3D%2Bh7aKOKLwENfjUMruWpjocgeto4Q%40mail.gmail.com.