Hi Phillip, It's in Unix Epoch time - this website will help you on how to convert it to a sensible date & time.
https://www.epochconverter.com/#:~:text=The%20Unix%20epoch%20(or%20Unix,01T00%3A00%3A00Z) . On Fri, 4 Nov 2022 at 19:38, Phillip Fischer <zs6f...@gmail.com> 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 weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/88e58150-35a5-4841-bea2-452d573b6f6dn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/88e58150-35a5-4841-bea2-452d573b6f6dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- "I and the public know what all schoolchildren learn Those to whom evil is done Do evil in return" W.H. Auden, "September 1, 1939" -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CA%2BxzKjBVSYm%2BqFuK%3Ds0mfbu2B0Y5gYmDeTOdWk2fyE_4dFi8Bw%40mail.gmail.com.