[eluser]Zahidul Ripon[/eluser]
[quote author="Mutsop" date="1289399358"]Well technicly that should work, maybe use the " instead of '
Just set DESC or ASC next to it.
(fieldname being the datestamp columnname)
Code:
$this->db->order_by = "fieldname DESC";
[/quote]
You didn't understand my question. I mean ORDER BY date(timestmpfield);
timestampfield=2010-06-05 13:30:00
date(timestmpfield)=2010-06-05