I export my pimatic.sqlite db to my local pc because I want to evaluate the log (PIR movements etc). For this I use a Sqlite Browser program so I can query the database.
The problem is that I cannot make any sense of the DateTime fields.
Example:
SELECT * FROM attributeValueNumber
returns
Id Time deviceAttributeId Value
"13" “1443191214812” “8” "83"
“23” “1443191464251” “8” “83”
SELECT datetime(time) as Tijdstip FROM attributeValueNumber
returns
1698789-19650109-20 -19:-12:-55
SELECT datetime(time,‘unixepoch’) as Tijdstip FROM attributeValueNumber
returns
-1413-03-01 13:07:12
Realy strange is that the time field in the first query shows different values, both the datetime(time) variants return the same value for all records?
Question?
How can i display the DateTime fields in a user (me ) readable format?