title: how to extract only time from DATETIME column
body: <p>I am trying to extract the time from each field for now what i get is:</p>
  
  <p>if i use the following code:</p>
  
  <pre><code>$row["real_stime"] = $row["start_time"];
  $row["real_etime"] = $row["end_time"];
  </code></pre>
  
  <p>i get this output:</p>
  
  <pre><code>"real_stime":"2015-11-18 07:18:00","real_etime":"2015-11-18 20:18:00"
  </code></pre>
  
  <p>and if i use this code:</p>
  
  <pre><code>$row["formated_start_time"] = date("H:i",$row["start_time"]);
  $row["formated_end_time"] = date("H:i",$row["end_time"]);
  </code></pre>
  
  <p>i get this output:</p>
  
  <pre><code>"formated_start_time":"00:33","formated_end_time":"00:33"
  </code></pre>
  
  <p>the output that i need is:</p>
  
  <pre><code>07:18,20:18
  </code></pre>