64位时间戳转换为可读值 [英] Convert 64bit timestamp to a readable value

问题描述

在我的数据集，我有两个时间戳列。首先是微秒，因为应用程序启动 - 例如，1400805323.第二个被描述为64位时间戳而我希望将显示时钟时间，用秒数的NTP格式，从1901年1月1日。

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.

的64位时间戳示例： 129518309081725000 129518309082059000 129518309082393000 129518309082727000 129518309083060000 129518309083394000 129518309083727000

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

有任何MATLAB /蟒蛇code，可以将此转换成可读的格式？

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

任何帮助非常AP preciated，

Any help much appreciated,

史蒂夫

推荐答案

假设今天生成这些值，2011年6月6日，这些值看起来像100纳秒间隔数自1月1日1601年这是Windows NT如何商店 FILETIME 。有关这阅读这篇博客比较集中的信息后雷蒙德陈。这些文章也显示了如何将它转换成别的

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

这篇关于64位时间戳转换为可读值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！