title: 18 digit timestamp to Local Time
body: <p>I came across Sq-lite database.I found our date time is stored in 18 digit time-stamp. </p>
  
  <p>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.)</p>
  
  <p>Here i give 18-digit time-stamp and its equivalent date time.</p>
  
  <h2>Time-Stamp                 Date-Time</h2>
  
  <p>362087070028927400         27-10-2014 15:06:57<br>
  362087302762879170         27-10-2014 15:22:06<br>
  362087302763135170         27-10-2014 15:22:06<br>
  362087302851460030         27-10-2014 15:22:06<br>
  362087302851716030         27-10-2014 15:22:06<br>
  362087302851716030         27-10-2014 15:22:06<br>
  362087305419799000         27-10-2014 15:22:16<br>
  362087307972777150         27-10-2014 15:22:26<br>
  362087310530875300         27-10-2014 15:22:36<br>
  362087313092045760         27-10-2014 15:22:46<br>
  362087315652448200         27-10-2014 15:22:56<br>
  362087318210802600         27-10-2014 15:23:06<br>
  362087320772741060         27-10-2014 15:23:16<br>
  362087323333655740         27-10-2014 15:23:26</p>
  
  <p>Thanks</p>