On Thursday, February 10, 2022 at 11:38:23 PM UTC-5 roger...@gmail.com wrote:
> Here are the last few lines of the select statement. I did not see any > null values. > > 1644552300|-89.0 > 1644552600|-89.0 > 1644552900|-89.0 > 1644553200|-89.0 > 1644553500|-89.0 > 1644553800|-89.0 > 1644554100|-89.0 > sqlite> > roger, the timestamps for these observations are recent - 1644554100 is Friday, February 11, 2022 4:35:00 AM UTC so it looks like *something* is inserting data for leafTemp1... try the query for the others. you can do it for multiple observations like this: select dateTime,leafTemp1,leafTemp2,leafWet1,leafWet2 from archive; select dateTime,soilTemp1,soilTemp2,soilTemp3,soilTemp4 from archive; select dateTime,soilMoist1,soilMoist2,soilMoist3,soilMoist4 from archive; for each query, check the latest dateTime that has data (non-null). to view the timestamp in human-readable form, use an epoch converter such as this one: https://www.epochconverter.com/ m -- 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/90f4601d-a62e-48e6-8489-978b061ce997n%40googlegroups.com.
