title: SQL Convert time in seconds into a local time zone
body: <p>I am working on query where time is stored in seconds.</p>
  
  <p>Right now the string I have shows the following.</p>
  
  <pre><code>Select schema.table.OpenDate_Seconds, '19700101' as Open Date
  </code></pre>
  
  <p>That gets me the sever time for the Open. How can I adjust this to get Central Time?</p>
  
  <p>Thanks in advance for looking and helping.</p>