title: SQL Server convert bigint column to a datetime
body: <p>I'm really a noob with msql and I need help for this:</p>
  
  <p>I have a table with only 3 columns:</p>
  
  <pre><code>devicename, status, timeticks
  </code></pre>
  
  <p><code>timeticks</code> is a 18 digit <code>bigint</code> value (for example <em>635924050579957219</em>) and I need to produce a report where <code>timeticks</code> is displayed as a datetime value.</p>
  
  <p>I use Microsoft SQL Server 2008 R2</p>
  
  <p>thanks in advance for your help.</p>