Problem with MySql functions on Active Record

[eluser]kmil0[/eluser]
Thanks phyromaniac
the final query is:

Code:

$query = $this->db->select(
                           array(
                              'u.name_u  as name',
                              'DATE_FORMAT(u.date_field, "%Y%m%d %H:%i%s") as date_field'
                           ), FALSE
                          );
                            
$query = $this->db->join("rol r", "r.code_r = u.cod_rol");
$query = $this->db->get("users u", $offset, $lenght);

Now it works!
but... where can I see the arguments for the db functions?
I don't see it in the user guide, however

Thanks to all again