WeeWX Datenbank bereinigen / Database clean up / delete unwanted data

Veröffentlicht am 16. August 2020

1	sqlite3 weewx.sdb

delete from archive where '2020-08-15 12:38:00'<datetime(dateTime,'unixepoch','localtime');

# delete data from 15.08.2020 till current time

delete from archive where datetime(dateTime,'unixepoch','localtime'<'2020-08-15 12:38:00');

# and vice versa

.quit

# to leave sqlite / db

# !!! backup your db before... !!!