Timestamps are stored as epochs (second since 1970). I often use https://www.epochconverter.com/ to help me convert.
The first number looks like a timestamps - 1321130400 = Saturday, November 12, 2011 8:40:00 (there abouts - depending on your time zone) On Fri, Feb 7, 2020 at 11:45 AM Troy Lass <[email protected]> wrote: > Ok, I'm trying to cleanup the future dates and I'm a little lost... > > I made a copy of the DB in /var/tmp and ran the following.... > root@deadduck:/var/tmp# echo "SELECT * FROM archive WHERE (windSpeed > > 80);" | sqlite3 /var/tmp/weewx.sdb > > 1321130400|1|10|30.083|34.79414|44.235535|73.5|53.200001|17.0|24.0|81.0|225.0|115.0|270.0|72.0|1.1|17.36064|53.200001|53.200001|0.0||||||||||||||||||||100.0|0.0|683.0|||||||||| > > 1321132200|1|10|30.073|34.784264|44.223541|72.099998|53.0|18.0|26.0|82.0|315.0|118.0|67.5|82.290001|1.25|19.047731|53.0|53.0|0.0||||||||||||||||||||98.0|0.0|684.0|||||||||| > > How do I identify the dates to delete? I'm assuming there's a date > field? What's the format? I need to delete all dates from 8/18/19 to > current. > > Thanks, > Troy > > > On Fri, Feb 7, 2020 at 10:03 AM vince <[email protected]> wrote: > >> On Friday, February 7, 2020 at 7:31:01 AM UTC-8, Troy Lass wrote: >>> >>> I live in a high wind area and like to watch what's happening when I'm >>> not around. It's not unusual for us to get over 100MPH and I like to know >>> when it gets up there... >>> >>> >>> >> That sure sounds like a reason to want to use the logger and weewx's >> capability to gracefully catch up when your location has a power outage..... >> >> That's a lot of MPH :-) >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/ic4IK_-eX4Q/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/e52b4eb7-2f33-40b8-bb92-61066300e849%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/e52b4eb7-2f33-40b8-bb92-61066300e849%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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/CALBrUnFjVdk3x94Z7T6q3urS1x4cvHumgAreHJmkoAvfF%3Ddyqg%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CALBrUnFjVdk3x94Z7T6q3urS1x4cvHumgAreHJmkoAvfF%3Ddyqg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- Peter Quinn (415)794-2264 -- 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/CAA1SM21NokLnBEOGH-u1zG8yQeQvS8y0ysrRxLV4XH3DbvvpLA%40mail.gmail.com.
