title: Query to convert from datetime to date mysql
body: <p>I am trying to get the date portion of a datetime field. I know I can get it with date_format, but that returns a string or "varchar" field. How can I convert the result to date and not as varchar?</p>
  
  <p>This is my query  returning the varchar:</p>
  
  <pre><code>(Select Date_Format(orders.date_purchased,'%m/%d/%Y')) As Date  
  </code></pre>
  
  <p>I tried several combinations from this question, but could not make it to work: </p>
  
  <p><a href="https://stackoverflow.com/questions/4596457/mysql-query-format-date-on-output">mysql query - format date on output?</a></p>
  
  <p>Any help is appreciated.</p>