Timestamp conundrum!

box

box

Associate
Joined
20 Nov 2005
Posts
1,228
Location
Bristol
I've spent the last hour or so pondering this, to no avail, so I'm unleashing it on you lovely people :p

I've got a sensor from which I'm sampling data every 2sec and then generating a CSV dump. Each record has a timestamp, with units of seconds, which look something along the lines of '405965164'.

For instance, the first 10 entries in the file I'm looking at are:

405965164
405965166
405965168
405965170
405965172
405965174
405965176
405965178
405965180
405965182

Basically, I'm trying to turn this into some meaningful format of date/time, but currently failing to get very far. It looks to me like this is seconds counted from some datum value. The year 2000 looked close, but alas was not correct.

405965164 corresponds to roughly 16:07 on 11/11/12.

Any guesses?
 
Year 2000 (01/01/2000) looks correct:

From here.

Calculation results
From date:Midnight between Friday, December 31, 1999 and Saturday, January 1, 2000

Added 405,965,164 seconds
Normalized to 4698 days, 16 hours, 6 minutes, 4 seconds

Resulting date: Sunday, November 11, 2012 at 4:06:04 PM
 
Back
Top Bottom