Parsing datetime from MySQL

[eluser]mddd[/eluser]
When you are only working with one single record, the performance issue will be probably not be noticable. So you don't have to change it for the sake of performance. But I think it is not the best way to take a date as a string from Mysql only to have Php turn it back into a date (with the strtotime() command) and then turning that back into a readable date again (with the date() command). That is like taking a detour. You can get the formatting straight from Myqsl using the Date_format() function in Mysql. It works just like the date() command in Php.

Code:

// in model
$this->db->select("*, date_format(date, '%M/%d/%Y') as human_date, date_format(date, '%H:%i:%s') as human_time", false);

// in view
<h2>&lt;?php echo $title; ?&gt;</h2>
<p>&lt;?php echo $human_date; ?&gt;</p>
<div>&lt;?php echo $body; ?&gt;</div>
<p>&lt;?php echo $human_time; ?&gt;</p>