title: How to get time format with hours and minutes from Mysql database?
body: <p>I am using codeigniter and got problem doing properly the query.</p>
  
  <pre><code>$query = $this-&gt;db-&gt;query('SELECT datetime ...');
  $resultdata['results'] = $query-&gt;result_array();
  
  foreach($results as $result)
  {
      echo "&lt;tr&gt;";
      echo "&lt;td&gt;".$result['datetime']."&lt;/td&gt;";
      echo "&lt;/tr&gt;";
  }
  </code></pre>
  
  <p>This code make result of the date in this format: 2015-04-11 02:45:19.
  How can I do the result only with HOURS and MINUTES? Thank you. </p>