title: Selecting a distinct date by day only from datetime (YYYY-MM-DD HH:MM:SS) in MySQL
body: <p>Executing this command brings me the following (all the dates from all columns, so it essentially did the same thing as SELECT date without distinct):</p>
  
  <pre><code>SELECT DISTINCT date FROM daily ORDER BY date DESC
  
  2013-02-12 16:40:52
  2013-02-06 11:48:49
  2013-02-06 11:36:41
  2013-02-06 11:35:59
  2013-02-04 19:38:12
  2013-02-04 18:12:30
  2013-02-04 09:58:41
  2013-02-04 09:43:01
  2013-02-04 09:35:51
  2013-02-04 09:30:22
  2013-02-04 09:24:57
  2013-02-04 09:21:09
  2013-02-04 08:50:13
  </code></pre>
  
  <p>What I need:</p>
  
  <pre><code>2013-02-12
  2013-02-06
  2013-02-04
  </code></pre>
  
  <ol>
  <li><p>Is there any way to alter my date table and convert it to YYYY-MM-DD instead?</p></li>
  <li><p>If not, is there a way to select distinct dates based only on the day?</p></li>
  </ol>