title: SQL Server - converting 13 digit numeric to datetime
body: <p>How can I convert a 13 digit numeric like 1314637182953 to <code>datetime</code> in SQL Server? Both casting and converting directly give an arithmetic overflow error! </p>
  
  <p>Same result with the query below:</p>
  
  <pre><code>select Convert(datetime, cast(START_DATE as varchar(8)), 112), * 
  from table
  </code></pre>