title: Converting varchar mm/dd/yy to date format yyyy-mm-dd
body: <p>I am trying to migrate data from one table to other. The issue is my target table has type date yyyy-mm-dd where as the source table has type varchar mm/dd/yy
  I tried a few thing but seems none worked.</p>
  
  <p>I am trying this but seems to give null</p>
  
  <pre><code>select year((datecreated)) * 10000 + month((datecreated)) * 100 + day((datecreated)) from employee
  </code></pre>
  
  <p>Here employee is my table and datecreated is my column.</p>
  
  <p>If someone has come across this please let me know how to fix it.</p>