title: Does Datetime(timestamp/1000, 'unixepoch', 'localtime') provide correct date considering DST?
body: <p>To Clarify... I have an existing Facebook application Database table which stores DateTime in epoch time. I want to query the tables and display the DateTime in local time taking into account DST is appropriate. </p>
  
  <p>Can anyone verify that the following SQL statement will properly account for DST (Daylight Savings Time) when showing the timestamp in local time (PST)? The timestamp is from a SQLite Facebook application (Apple).</p>
  
  <pre><code>Select Datetime(timestamp/1000, 'unixepoch', 'localtime') As ConvertedDateTime
    FROM XYZ
  </code></pre>
  
  <p>I've been searching all the sites, but haven't found a clear answer. A few pages I have found that discuss the subject include:</p>
  
  <p><a href="http://sqlite.1065341.n5.nabble.com/Date-and-time-td15487.html" rel="nofollow noreferrer">http://sqlite.1065341.n5.nabble.com/Date-and-time-td15487.html</a></p>
  
  <p><a href="http://geeklog.lucid.net.au/article-20091211084306281.html?story=20091211084306281" rel="nofollow noreferrer">http://geeklog.lucid.net.au/article-20091211084306281.html?story=20091211084306281</a></p>
  
  <p><a href="https://stackoverflow.com/questions/3850605/how-do-i-convert-from-unix-epoch-time-and-account-for-daylight-saving-time-in-c">How do I convert from unix epoch time and account for daylight saving time in C#?</a></p>
  
  <p>Thank you for anyone that can clearly clarify this question.</p>