title: Computed Column Formula
body: <p>I've created a computed column with this formula:</p>
  
  <pre><code>(CONVERT([datetime],(CONVERT([varchar],[TradeDate])+' ')+CONVERT([varchar],[TradeTime])))
  </code></pre>
  
  <p>but when I save the table, the formula automatically changes to: </p>
  
  <pre><code>(CONVERT([datetime],(CONVERT([varchar],[TradeDate],0)+' ')+CONVERT([varchar],[TradeTime],0),0))
  </code></pre>
  
  <p>So it causes this problem: </p>
  
  <p>Suppose <code>TradeDate</code> is: <code>2012-08-13</code> and <code>TradeTime</code> is: <code>10:29:59.0000000</code> </p>
  
  <p>and instead of showing <code>2012-08-13 10:29:59.000</code>, it shows <code>2012-08-13 10:29:00.000</code>, because of changing the formula. </p>
  
  <p>What's the solution?</p>