It's actually much simpler. The field 'dateTime' is already in unix epoch time. So, you want
* delete from archive where dateTime>1578739140 and dateTime<1578741360;* Then rebuild the daily summaries. -tk On Sat, Jan 11, 2020 at 7:29 AM Neil S <[email protected]> wrote: > I am trying to delete data between two time points as it is erroneous (I > updated and for a short period the station type was reset to simulate). > > The time points are 11/1/20 at 10:39:00 and 11:16:00 (so I think I have > the right unixepoch timestamps) > > I have worked out how to delete data that is older or newer than any one > point but not between. In theory the following should work > > *sqlite3 /var/lib/weewx/weewx.sdb* > > *delete from archive where datetime(dateTime,'unixepoch','localtime') > BETWEEN '1578739140' AND '1578741360';* > *.exit* > > > but it doesnt and just appears to delete all data up to the last time > stamp. All historic data seems to have been deleted (including all the NOAA > data). > > I have also tried > > *sqlite3 /var/lib/weewx/weewx.sdb* > *delete from archive where > (datetime(dateTime,'unixepoch','localtime')>1578739140) AND * > *(datetime(dateTime,'unixepoch','localtime')<**1578741360);* > *.exit* > > > Strangely the database size seems to be the same though - so is it just a > case of me panicking that I am loosing data and I need to wait for tables > to be rebuilt? > > TIA > Neil > > -- > 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/0f6dc72d-4366-4e63-922a-bde2275822b7%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/0f6dc72d-4366-4e63-922a-bde2275822b7%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/CAPq0zEC6LuCYs43yCNw1eiAivjZcXLj5UEiy-OJ%3DjQ5FYAmgvg%40mail.gmail.com.
