title: How to separate DATE and TIME from DATETIME in MySQL?
body: <p>I am storing a <code>DATETIME</code> field in a table. Each value looks something like this:</p>
  <blockquote>
  <p>2012-09-09 06:57:12</p>
  </blockquote>
  <p>I am using this syntax:</p>
  <pre><code>date(&quot;Y-m-d H:i:s&quot;);
  </code></pre>
  <p>Now my question is, while fetching the data, how can get both date and time <em><strong>separately</strong></em>, using a single MySQL query?</p>
  <p>Date like &quot;<strong>2012-09-09</strong>&quot; and time like &quot;<strong>06:57:12</strong>&quot;.</p>