I have a trend saving values and I made a copy of the SQlite file and loaded it into SQlite Studio. I understand the TS is epoch value in seconds which makes sense when I put it through a converter. My value 2 and value 3 are boolean, which makes sense. What isn't making sense is my Value 1. It's reading a real variable that is a temperature value. But it isn't making sense to me.
For instance it has a value of 1076546816 for something that should be between 2 and 4 degrees C.
How should I go about converting this?Here is the SQlite file.