I have a program that logs several lots of data to a .DB file.
In the GUI for the program there is an option to clear the data but not to edit it.
For example it records data at various time intervals, hourly, weekly, monthly, yearly.
It is possible to clear any of them completely but not to retain the last x amount of readings which is what I would like to do.

I was pointed at a program called SQLiteSpy, this will open the file but I do not have the faintest idea how to edit it.
Also the dates that it shows are in a numerical code, I assume that the higher the number the later the date but I am not certain about that.

There is no help file with SQLiteSpy and I cannot find any information on the website that I can understand, programming is beyond my capabilities.

Any help appreciated.