I just wanted to read the power data from my lawn mower and exported the data as so called csv.
This is how the content looks like:
"deviceId","name","timestamp","value"
196,"Rasenmaeher",1523595578,6.225
First of all, this so called CSV data can not be imported in excel directly, it must be pre-processed first to lead to a reasonable result.
my main question is about the timestamp. what format is this?
1523595578 how to translate this into a date and time?
anyone