SQL Server - Convert VarChar to Date in ALTER TABLE
<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>