Codeigniter：按升序排序

Question

Hi this is my model code for ordering and getting the data:

$this->db->order_by($oBy, "asc");
$query = $this->db->get('books');

Everything is working fine, however in my database i am storing the date as a string, e.g. 01-Jan-2014.

Therefore when i order the date it will order it by the day and not year, may i know how can i solve it by sorting by the year, however the data will still display out as 01-Jan-2014 and also it will be displayed in ascending order? Thank you!

Error:

Answer 1

$this->db->select('str_to_date('.$oBy.', "%d-%b-%Y") day',false);//select your colum as new column name wich is converted as str ot date
//yo can do select more.
$this->db->order_by('day','ASC');
$query = $this->db->get('books');

This will solve your problem