title: SQL SELECT NOW()
body: <p>Hey ya'll sorry for all the caps in the title, but its actually suppose to be like that.</p>
  
  <p>I am running this in query</p>
  
  <p><code>SELECT NOW()</code></p>
  
  <p>and it returns this</p>
  
  <p><code>2012-05-14 17:35:37</code></p>
  
  <p>how do I remove the time, I only want the date.</p>