Re: [weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread V. Kelly Bellis
Thank you for the helpful suggestions, but neither approach worked. This is only a minor nuisance, with the larger item of the cause for the 75 minutes worth of missing data remaining unknown. As far as I have observed thus far using the Atmocom device, + the RPi 3B+, the weewx driver and weew

Re: [weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread Andrew Milner
don't you have to delete the 'dateTime' in blue in the drop down list shown and enter Tom's formatting command as the format for the dateTime field. On Friday, 29 March 2019 17:24:48 UTC+2, V. Kelly Bellis wrote: > > Thanks for all of the helpful replies. > > Tom, I tried as you suggested; i.e.

Re: [weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread Thomas Keffer
I am not a big fan of DBBrowser for sqlite, but one nice feature it has is the ability to apply display formats to columns. Just right click on the dateTime column, select "Edit display format", and type in the following: *datetime(`dateTime`, 'unixepoch', 'localtime')* Now the column will be di

Re: [weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread Greg Troxel
"V. Kelly Bellis" writes: > Before seeing your kind reply, I was dividing the whole mess by 60, then > 60, then 24, then 365.2422 and figured we were looking at 19700101 > 00:00:00; however, I still don't understand the deliberate obfuscation for > any human reading the weewx.sdb It is not ob

Re: [weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread p q
Trust me. It's the best way. No worries about time zones. No daylight savings time adjustments. It works everywhere. When a person needs to read it, there are good tools in programming languages to convert it to human readable forms. If you're using python, the datetime library can convert to and f

[weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread V. Kelly Bellis
Thanks for the link. Before seeing your kind reply, I was dividing the whole mess by 60, then 60, then 24, then 365.2422 and figured we were looking at 19700101 00:00:00; however, I still don't understand the deliberate obfuscation for any human reading the weewx.sdb On Friday, March 29, 201

[weewx-user] Re: How to Read dateTime Field in weewx.sdb?

2019-03-29 Thread peterquinn925
Google for Unix Epoch. It's the number of seconds since Jan 1 1970. You can find online converters like this one:https://www.epochconverter.com/ On Friday, March 29, 2019 at 6:32:18 AM UTC-7, V. Kelly Bellis wrote: > > Something happened with my RPi-weewx-Atmocom experiment running in the wee >