[SOLVED]date_format not working

[eluser]Zeeshan Rasool[/eluser]
You are making a mistake i think in selecting columns line,
Ok use it like this simple query. Also make sure order by variables and limit has a value.

Code:

$this->db->join('sec_dataset k','ar_so.status=k.data_value AND k.data_code = "TRAN_STATUS"','left');
        $this->db->select("DATE_FORMAT(ar_so.so_date,'%b %d, %Y') as dateFormated");
        $this->db->order_by($sortname,$sortorder);
        $this->db->limit($rp, $start);
        $query = $this->db->get("ar_so");

And then replay