topic Re: In the CSV files from reports, what is the Timestamp counted in in Aerohive Migrated Content

In the CSV files from reports, what is the Timestamp counted in

malcolm_snelgro — Mon, 14 May 2018 09:55:39 GMT

Hi all,

Does anyone know what the format is from the Timestamp attribute in the Aerohive NG CSV files from reports? I assume it is the number of seconds, but from when?

Regards,

Malcolm

Re: In the CSV files from reports, what is the Timestamp counted in

malcolm_snelgro — Wed, 16 May 2018 09:03:27 GMT

I calculated it for myself. It appears to be milliseconds from the 1st of Jan 1970 for whatever reason. I used Google to count the days so I am not sure it if accounts for leap years etc, but it is in a few days of this date so I am assuming that this is correct.

Re: In the CSV files from reports, what is the Timestamp counted in

dsouri — Thu, 24 May 2018 02:23:03 GMT

Hi Malcom,

Can you put a screenshot here? Please omit any sensitive data/information.

Thank you,

David Souri

HiveCommunity Moderator

Re: In the CSV files from reports, what is the Timestamp counted in

malcolm_snelgro — Thu, 24 May 2018 09:54:49 GMT

Here is one of the timestamp in a CSV file.

I since realised this is the Unix standard for timestamps and there are websites which will help you convert from the Unix timestamp to Date & Time formats.

However the reporting period sometimes seems off, in that the csv file timestamp starts at a different time then the reporting interface and the email with the files reports it to start.

Re: In the CSV files from reports, what is the Timestamp counted in

AnonymousM — Tue, 25 Dec 2018 16:50:38 GMT

Any body know, how to convert?