title: How SQLite.Net-PCL handle UTC time
body: <p>I am using below code:</p>
  
  <p>using new SQLite.Net.SQLiteConnection(new SQLitePlatformWinRT(), DBPath) to get SQLiteConnection 
  and create table.</p>
  
  <p>Class contain DateTime DataType</p>
  
  <pre><code>class Transaction 
      {
          [SQLite.Net.Attributes.PrimaryKey, SQLite.Net.Attributes.AutoIncrement]
          public int QId { get; set; }
          public DateTime PurchaseDate { get; set; }  
          public int Amount {get;set;}
          Public string ItemCode {get;set;}      
      }
  </code></pre>
  
  <p>Insert Data As follows:</p>
  
  <pre><code>var db = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), DBPath);
  
   var newItem = new Transaction()
    {  
       PurchaseDate = DateTime.Now,            
       Amount = 100,
       ItemCode = "Abc-C10"               
    };
  
   db.Insert(newItem);
  </code></pre>
  
  <p>The date will be stored as Ticks(e.g. 636071680313888433) and this is UTC time.<br/></p>
  
  <p>1) using above DateTime.Now, If my Computer time setting is<br/></p>
  
  <p>1a) in British Time, <br/></p>
  
  <p>will the above code : purchase = DateTime.Now  be converted correctly?<br/></p>
  
  <p>1b) in Usa Time,<br/></p>
  
  <p>will the above code : purchase = DateTime.Now  be converted correctly?<br/></p>
  
  <p>How to handle this tick in SQL-statement?<br/></p>
  
  <p>How to select all transaction from ,say, a date range ? say , 2016-07-10  to 2016-07-20 ?</p>
  
  <p>Thanks</p>