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 from it. There's a SQL function DATEADD that can do it too. I've not used it, but here's a link: https://stackoverflow.com/questions/4787827/converting-epoch-timestamp-to-sql-serverhuman-readable-format
On Fri, Mar 29, 2019 at 6:55 AM V. Kelly Bellis <[email protected]> wrote: > 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, 2019 at 9:44:35 AM UTC-4, [email protected] wrote: >> >> 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 hours of the morning and I'm trying decipher the times of when these >>> happenings occurred, but cannot makes much sense out of the dateTime >>> field in the /var/lib/weewx/weewx.sdb which apparently are some measure of >>> seconds. >>> >>> What have I missed? I was unable to find a global Search mechanism >>> covering the whole of http://weewx.com/docs/ = does such a feature yet >>> exist? >>> >>> How difficult would it be to add another column to the weewx.sdb >>> allowing YYMMDD HH:MM:SS.SS to be more easily understood? >>> >>> I just want to know what time things went off the rails... and when the >>> ship righted itself. >>> >>> [image: I-just-want-to-know-what-time-things-went-off-the-rails.png] >>> >>> >>> -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- Peter Quinn (415)794-2264 -- 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]. For more options, visit https://groups.google.com/d/optout.
