CSV Energy Export

[s_pnz 0]

Hello,

 

I've tried to make an export of the energy data (function available under General/Data Export) in order to keep some historical data for future comparisons.

 

I can't understand the format of the "timestamp" column, it's a long numer with no apparent correlaton with date/time.

 

Anyone knows how to decode this number?

 

Thank you in advance

 

Greetings

Please login or register to see this attachment.

[SmartHomeEddy 1,005]

It is a time in seconds (since Thursday 1 January 1970). More explanation: 

Please login or register to see this link.

 

 

Look for example here to convert it to human readable: 

Please login or register to see this link.

You can convert it in your spreadsheet with probably an EPOCHTODATE function. 

 

[s_pnz 0]

Thank you very much!