title: mysql convert date from mm-dd-yyyy to YYYY-MM-DD format
body: <p>I want to convert  given date  from <strong><code>mm-dd-yyyy</code></strong> to <strong><code>YYYY-MM-DD format</code></strong> </p>
  
  <p>I have tried following </p>
  
  <pre><code>SELECT DATE_FORMAT("09-02-2018",'YYYYMMDD')
  
  SELECT DATE_FORMAT("09-02-2018", "%MM %dd %YY");
  
  SELECT CURDATE("09-02-2018");
  
  SELECT DATE_FORMAT("09-02-2018", "%Y-%m-%d")
  </code></pre>
  
  <p>It works fine for current date, but not for a given date.</p>