MySQL DATE_FORMAT with Active Record

[eluser]Référencement Google[/eluser]
Whoooops... just got it !
If it can help somebody:

Code:

function list_all($lang, $limit = FALSE, $offset = FALSE)
    {

        $this->db->select('*');
        $this->db->select("DATE_FORMAT(datetime, '%d.%m.%Y à %H:%i:%s') AS datetime");

        $this->db->where('lang', $lang);
        $this->db->limit($limit);
        $this->db->offset($offset);
        $this->db->order_by('datetime', 'desc');
        $query = $this->db->get('news');

        return $query->result();
    }