1 |
sqlite3 weewx.sdb |
1 2 3 4 5 6 7 8 9 10 11 12 |
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... !!! |