title: T-SQL - changing datetime to date data type?
body: <p>I have a column <code>BirthDate</code> in a table that is using the <code>datetime</code> data type. Currently, the values resemble the format <code>1987-12-30 00:00:00.000</code>.</p>
  
  <p>I would like to update all the rows of this table, changing them to the following format with the <code>date</code> data type: <code>1987-12-30</code></p>
  
  <p>I can run a SELECT...</p>
  
  <pre><code>SELECT CONVERT(date, BirthDate) FROM CUSTOMERLIST
  </code></pre>
  
  <p>But this is only affecting the display. I would like for it to update the entire column and also change the data type of that attribute as well. Any assistance would be greatly appreciated!</p>