title: SQLite query that converts Unix epoch date/time and works with DST in C#
body: <p>I am querying and retrieving data from an SQLite3 database in C# which stores its date/times in Unix epoch time</p>
  
  <p>Some are stored as the number of seconds since 01/01/1970</p>
  
  <p>And some are stored as the number of seconds since 01/01/2001</p>
  
  <p>This is all fine as My query can figure the difference and apply the correct date/time conversion</p>
  
  <p>However I am unable to figure a way I can do this to incorporate Daylight Saving Time</p>
  
  <p>Is there a way I can differentiate between DST?<br>
  Also is there a way I can get the timezone from the Unix epoch time?</p>
  
  <p>The query I am using is below, any help with this would be great</p>
  
  <pre><code>string query = "SELECT case when date&lt;978307200 then datetime(date + 978307200,'unixepoch') else datetime(date,'unixepoch') end
  AS [DATE / TIME]
  FROM message
  ORDER BY ROWID";
  </code></pre>