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
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 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
"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
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
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,
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
>
