usUnits==1 → rainRate is inches/hour. are you looking for > 13 inches/hour?
also, for easier reading of timestamps, you could use SELECT datetime(dateTime,’unixepoch’,’localtime'),usUnits,rainRate FROM archive ... > On 7 Jul 2020, at 5:06 pm, Andre <[email protected]> wrote: > > Thanks again, Gary. > This is my result of the query > > echo "SELECT dateTime,usUnits,rainRate FROM archive WHERE (RainRate > 13);"| > sqlite3 /home/pi/weewxcopy.sdb > 1581284100|1|13.3385826805 > 1581284400|1|13.3385826805 > > I don't understand the dateTime 1581284100 which means 02-09-2020, 22:35:00. > But my "bad data" are from 4 July 2020 09:33. I can't see where the "bad > data" come from. > -- 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/23A9AC0A-C1DE-4CF6-ACD1-3D27D96AA08C%40gmail.com.
