It's hard to read, but that's probably right. You can confirm my just selecting the most relevant columns. Try this for your SELECT statement:
echo "SELECT dateTime, datetime(dateTime,'unixepoch','localtime'), rainRate from archive where rainRate > 100;" | sqlite3 /var/tmp/datbasebu/weewx.sdb This print out just timestamps, the local time, and rain rates. Easier to read. -tk On Tue, Sep 25, 2018 at 3:12 AM Glenn F <[email protected]> wrote: > > 1. Cheers Thomas,.... if you have time to view the attched imge and > see if I'm in the right direction,.. I got swamped in numbers,, love a > little clarification... > > > On Monday, 24 September 2018 23:30:50 UTC+12, Thomas Keffer wrote: >> >> Hello, Glenn >> >> See the Wiki entry Clean up old "bad" data >> <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data> and see >> if that doesn't answer your question. If not, come back and we'll dig in >> deeper. >> >> -tk >> >> On Mon, Sep 24, 2018 at 12:38 AM Glenn F <[email protected]> wrote: >> >>> It has probably been asked, and if so point me in the direction please. >>> I'd love to delete this record, I never built an ark nor got flooded out, >>> so would love this to show the actual , real, value.. >>> >>> Running a FineOffsetUSB system . >>> >>> Glenn.. >>> >>> -- >>> 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.
