MySQL: Changing column type and date time format
<p>My DB currently have 'date' column setup as varchar(20) and I date is formatted like this:</p>

<pre><code>1/13/2015 20:00
</code></pre>

<p>I would like to run an update on my DB to change column type to datetime and change format of my current date to something more typical like</p>

<pre><code>yyyy-mm-dd hh:mi
</code></pre>

<p>Can this be done in MySQL?</p>