title: MySql Character to Date Format conversion returns null
body: <p>I have a char field which is having Date in it as <strong>'26-Nov-2011'</strong>
  I want this date to be printed in <strong>YYYY-MM-DD</strong> format. </p>
  
  <p>I used following date conversion which is not allowing me to do.</p>
  
  <pre><code>select date_format('26-Nov-2011','%d-%b-%y')
  </code></pre>
  
  <blockquote>
    <p>returns Null.</p>
  </blockquote>
  
  <p>I know date_format function can accept date in YYYY-DD-MM format but<br>
  Please let me know how to convert a Character to Required Date Format</p>