Rearrange int value from MMDDYYY to YYYYMMDD using MySQL
<p>I have a VARCHAR data type in field name date:</p>

<pre><code>DATE

09282016
09272016
</code></pre>

<p>I want to arrange it to:</p>

<pre><code>DATE
20160928
20160927
</code></pre>

<p>How can I do that in MySQL?</p>