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.
