title: how to remove time from datetime
body: <p>The field DATE in the database has the following format:</p>
  
  <pre><code>2012-11-12 00:00:00
  </code></pre>
  
  <p>I would like to remove the time from the date and return the date like this:</p>
  
  <pre><code>11/12/2012
  </code></pre>