Just playing a bit around with the pimatic-database. Would like to export some device collected data. What I am wondering is: How is the time stored inside database?
So if I try to e.g. get the maximum measured temperature ever I fire:
select id, datetime(time,'unixepoch'), MAX(CAST(value AS FLOAT)) from attributeValueNumber where deviceAttributeId=88;
But what I get is:
736428|1970-01-01 00:00:00|34.5
where the time decoding is wrong. So how to decode time correctly?
Thanks + cheers,
DerIng