title: SQL Server - Convert VarChar to Date in ALTER TABLE
body: <p>Saw a few threads on this but I have a specific instance where I am trying to do the conversion within an ALTER TABLE statement.</p>
  
  <pre><code>ALTER TABLE Leads
  ALTER COLUMN [Created Date] Date
  </code></pre>
  
  <p>This is throwing an error:</p>
  
  <blockquote>
    <p>Msg 241, Level 16, State 1, Line 34<br>
    Conversion failed when converting date and/or time from character string.<br>
    The statement has been terminated.</p>
  </blockquote>
  
  <p>Created Date is currently set as (varchar(max), null) </p>