[SOLVED]date_format not working

[eluser]imn.codeartist[/eluser]
there must be something wrong with your join queries as i dont see its CI problem.

print the query and try running in the mysql see if that generated query works.

I have no problem using DATE_FORMAT

here is the test code of me and its giving desired output

Code:

$this->db->select("date_format(t.ticket_post_date,'%b %d, %Y'),m.username",FALSE);
        $this->db->from("tblticket t");
        $this->db->join("tbl_memberinfo m","t.user_id=m.user_id");
        $query=$this->db->get();
        echo $this->db->last_query();
        print_r($query->row());

and the Output is:

stdClass Object (
[date_format(t.ticket_post_date, '%b %d, %Y')] => Jul 07, 2009
[username] => haico )