title: Convert INT to DATETIME (SQL)
body: <p>I am trying to convert a date to datetime but am getting errors. The datatype I'm converting from is (float,null) and I'd like to convert it to DATETIME.</p>
  <p>The first line of this code works fine, but I get this error on the second line:</p>
  <blockquote>
  <p>Arithmetic overflow error converting expression to data type datetime.</p>
  </blockquote>
  <pre><code>CAST(CAST( rnwl_efctv_dt AS INT) AS char(8)),
  CAST(CAST( rnwl_efctv_dt AS INT) AS DATETIME),
  </code></pre>