A little more background. It's a unix epoch datetime. The number of seconds since 1970 iirc. Google unix epoch.
On Fri, Nov 4, 2022, 10:14 AM Glenn McKechnie <[email protected]> wrote: > unixepoch, epochtime, unixtime > > from a linux terminal... > > $ date -d now +'%s' > 1667553105 > > $ date -d @1667553105 > Fri 04 Nov 2022 20:11:45 AEDT > > man date > > within a mysql (mariadb)... > SELECT FROM_UNIXTIME(datetime, '%d-%m-%Y %H:%i') from archive WHERE > dateTime = 1667340000; > > there'll be something similar for sqlite > > On 04/11/2022, Phillip Fischer <[email protected]> wrote: > > I hope that someone would be able to point me in the right direction. > > > > I am aiming to use Weewx to log data from a weather station console of a > > station that is set up in a remote, out of the way area as part of my > > research. Due to an oversight in Station specs, I was given a station > that > > will need to be downloaded every two weeks or else the data is > overwritten, > > > > but getting to the site every two weeks is not going to happen! > > > > I've got the station running, connected to a Raspberry Pi Zero 2 and it > is > > working and logging data without issue. > > > > It is easy to get into the .sdb and convert the data to .csv for export > to > > analyse the data off site. There is no cell signal, wifi or any other way > > of connectivity at the site so the data needs to be physically > downloaded. > > > > I am however a bit stumped as I cannot figure out in what format the date > > and time is stored as. It seems to be a serial number, but I am not sure > > how to convert that back to Date and Time. > > > > Does anyone perhaps have an idea on how to get the conversion done? I > > cannot find any explanation in the documentation about the units of the > > database values. > > > > dateTime > > 1667481600 > > 1667481900 > > 1667483700 > > 1667484000 > > 1667484300 > > 1667484600 > > 1667484900 > > 1667485200 > > 1667485500 > > 1667485800 > > 1667486100 > > > > -- > > 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/88e58150-35a5-4841-bea2-452d573b6f6dn%40googlegroups.com > . > > > > > -- > > > Cheers > Glenn > > rorpi - read only raspberry pi & various weewx addons > https://github.com/glennmckechnie > > -- > 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/CAAraAzi8A02nYOkcwdDuz0ig_omcGZpWEKdTr%2B1fy9Oda1Pvog%40mail.gmail.com > . > -- 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/CAA1SM225DWn9ySN0QBtJ_2nF%2Ba8%2B55G-MTBwWj5Sj3k60OLezg%40mail.gmail.com.
