Convert 64bit timestamp to a readable value

datetime 64-bit timestamp ntp
Steve Trawley picture Steve Trawley · Jun 6, 2011 · Viewed 17.6k times · Source

In my dataset I have two timestamp columns. The first is microseconds since application was started - e.g., 1400805323. The second is described as 64bit timestamp which I'm hoping will indicate clock time, using NTP format of number of seconds from 1/1/1901.

Example of '64bit' timestamps: 129518309081725000 129518309082059000 129518309082393000 129518309082727000 129518309083060000 129518309083394000 129518309083727000

Is there any matlab/python code that could convert this into a readable format?

Any help much appreciated,

Steve

Answer

Rom picture Rom · Jun 6, 2011

Assuming that these values were generated today, June 6th 2011, these values look like number of 100-nanosecond intervals since Jan 1st year 1601. This is how Windows NT stores FILETIME. For more concentrated info on this read this blog post of Raymond Chen. These articles also show how to convert it to anything else

Related questions

How to get the current time in Python

What is the module/method used to get the current time?

Read More
Converting string into datetime

I've got a huge list of date-times like this as strings: Jun 1 2005 1:33PM Aug 28 1999 12:00AM I'm going to be shoving these back into proper datetime fields in a database so I need to magic them into real datetime objects. This …

Read More
How do you get a timestamp in JavaScript?

How can I get a timestamp in JavaScript? Something similar to Unix timestamp, that is, a single number that represents the current time and date. Either as a number or a string.

Read More