Browse FAQs

NetBotz History Export date is seen as a Linux Time Stamp

Published date: 20 July 2020


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

Product Line:



NetBotz History Export.


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"


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 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 />

You can also cut off the rest of the numbers by using a formula like this:
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 ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.