title: Epoch Date Conversion to SQL Server
body: <p>Good Day,</p>
  
  <p>I have a question. What type of epoch date's are these and how would I convert them into a SQL Server <code>datetime</code> format. </p>
  
  <pre><code>37564691530
  37564704499
  37564708633
  37564721033
  37564743361
  37564746236
  </code></pre>
  
  <p>I have googled for 2 days and cant find anything except this formula which gives me an arithmetic overflow message when i try to convert it.</p>
  
  <pre><code>select 
      DATEADD(ss, 37564691530 - 3600 * 5, CONVERT(DATETIME, '1900-01-01 00:00:00', 102)) 
  </code></pre>
  
  <p>Any help would really be appreciated.</p>