title: I need to update my table by converting a column from int into date in sql server
body: <p>I want to update the column transe_date  from int  into  date ..</p>
  
  <p><img src="https://i.stack.imgur.com/atCMV.png" alt=""></p>
  
  <pre><code>update fci
  set fci.transe_date= convert(date,convert(varchar(8),transe_date));
  </code></pre>