本地时间的18位数时间戳 [英] 18 digit timestamp to Local Time

问题描述

I came across Sq-lite database.I found our date time is stored in 18 digit time-stamp.

Please help me how to convert it to Local Time. (I tried to convert it(No.of milliseconds from 1900). But i did not get it.It shows 29 days difference. I added 29 days of milliseconds to time. But time output is wrong.My assumption is, it will be NTP time.)


Here i give 18-digit time-stamp and its equivalent date time.

Time-Stamp                 Date-Time
--------------------------------------------
362087070028927400         27-10-2014 15:06:57
362087302762879170         27-10-2014 15:22:06
362087302763135170         27-10-2014 15:22:06
362087302851460030         27-10-2014 15:22:06
362087302851716030         27-10-2014 15:22:06
362087302851716030         27-10-2014 15:22:06
362087305419799000         27-10-2014 15:22:16
362087307972777150         27-10-2014 15:22:26
362087310530875300         27-10-2014 15:22:36
362087313092045760         27-10-2014 15:22:46
362087315652448200         27-10-2014 15:22:56
362087318210802600         27-10-2014 15:23:06
362087320772741060         27-10-2014 15:23:16
362087323333655740         27-10-2014 15:23:26


Thanks

推荐答案

我不可能在msdn中检查这个引用。



http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.90%29.aspx [ ^ ]

I don't its possible check this reference in msdn.

http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.90%29.aspx[^]

这篇关于本地时间的18位数时间戳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！