Thank You! I am fairly new to the world of linux and learning new things each day! I appreciate your time to answer my question.
I've successfully converted the time and date stamps! On Friday, 4 November 2022 at 11:33:50 UTC+2 [email protected] wrote: > 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/9a6f9434-8477-46d1-a9c3-bd6197ba1990n%40googlegroups.com.
