Bingo!
Thank you for your help.
Neil
On Saturday, 11 January 2020 14:46:36 UTC, Thomas Keffer wrote:
>
> 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
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 wrote:
> I am trying to delete data between two
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