title: How to copy data of datetime column to another column in SQL
body: <p>How can I copy data of all column from datetime column to another column without hour minute and second.</p>
  
  <p>Table A </p>
  
  <pre><code>      ID    Time                              Time2
  
         1      2012-08-08 00:38:59.783         NULL
  </code></pre>
  
  <p>After copy </p>
  
  <pre><code>      ID     Time                              Time2
  
        1      2012-08-08 00:38:59.783          2012-08-08
  </code></pre>