php - Codeigniter: Order by ascending date

436

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: enter image description here

513

Answer

Solution:

$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
//you can do select more.
$this->db->order_by('day','ASC');
$query = $this->db->get('books');

This will solve your problem

810

Answer

Solution:

I suppose that $oBy is your column name

$this->db->order_by("str_to_date(" . $oBy . ", '%d-%b-%Y')", "asc");

%d = Day of the month, numeric (00..31)

%b = Abbreviated month name (Jan..Dec)

%Y = Year, numeric, four digits

People are also looking for solutions to the problem: php - Blueimp File Upload Pass Variable

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question