"V. Kelly Bellis" <[email protected]> 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 obfuscation. It is the standard representation of time as defined by the POSIX specification. Databases are for machine processing, and programs that display data from databases for humans should format/transform appropriately. You are running into the difference between "human readable" and "nerd readable" :-) On the command line, "date +%s" will show the current time as a POSIX time_t, and "date -r N" will show the human-readable date/time at time_t value N. Very likely you can put some sort of conversion function into a sql select statement when grabbing time and whatever for inspection. But beware of zones and DST. -- 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.
