Technical FAQs

Ask a Question

NetBotz History Export date is seen as a Linux Time Stamp

Issue:

NetBotz History Export date is seen as a Linux Time Stamp.

Product Line:

NetBotz

Environment:

NetBotz History Export.

Cause:

NetBotz is based on the Linux operating system and as such much of it's data uses a Linux Time Stamp The Exported data may look something like this:
"Sensor Pod (integrated)";"Temperature";"1465097276057";"30.00"

Resolution:

It is unlikely this will be changed in a future revision so if it is necessary to view this as a date, the information can always be imported into a spread sheet application such as Microsoft Excel.

I can translate 1465097276057 on the epochtime.com page but in Microsoft Excel, the number does not translate easily. I must delete the last 3 digits just to be able to use the suggested Excel formulae:
=(((C2/60)/60)/24)+DATE(1970,1,1)<br />
or
=C2/(60*60*24)+"1/1/1970"

You can also cut off the rest of the numbers by using a formula like this:
=(((LEFT(C2,10)/60)/60)/24)+DATE(1970,1,1)
When formatted properly using a time format, the result should look like this:
6/5/16 3:27 AM
 
Was this helpful?
What can we do to improve the information ?