Merchant Archive

I saved a message and reverse engineered the TIMESTAMP to known date/time in message using Excel.

The timestamp is number of seconds elapsed since a reference date & time.

Looks to me like the reference date/time is: 1 Jan 1970 06:00:00

To convert timestamp to date & time:

days = @int(timestamp/86400) {divide by total number of secs in day to find number of days}

remainder = timestamp - (days * 86400) {find number of seconds remaining on current day}

hour = @int(remainder / 3600) {find number of hours}

remainder = remainder - (hour * 3600)

minutes = @int(remainder/60) {find number of minutes}

remainder = remainder- (minutes * 60)

seconds = remainder

In Excel, add days to reference date (1/1/1970) to get the current date.