title: Mysql Wrong Date Format
body: <p>Hi I am trying to convert dd-mm-yy to yy-mm-dd in mysql but I'm getting wrong date as below :</p>
  
  <pre><code> query :  select STR_TO_DATE('01-09-2018','%Y-%m-%d')
     result:  2001-09-20
  </code></pre>
  
  <p>Please help me to solve this issue. </p>