On Friday, July 5, 2019 at 12:38:30 PM UTC-7, Thomas Keffer wrote: > > It would be useful to see what actually ended up in the database. Use the > tool sqlite3 to do this (you may have to install). > > *sqlite3 weewx.sdb* > sqlite> *select dateTime, datetime(dateTime,'unixepoch','localtime'), > windSpeed, windDir from archive limit 20;* > >> one thing I normally do is add a second 'dateTime' to the end of the select statement, so you can see nulls (which aren't always visually obvious), as dateTime is always going to be there
*select dateTime, datetime(dateTime,'unixepoch','localtime'), windSpeed, windDir, dateTime from archive limit 20;* -- 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/f479f70f-c396-4d76-8d09-8139cfb17c5e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
