Using Mysql function names in the active record set select method

[eluser]vigna[/eluser]
Hi,
I am using active recordset object.
when I pass a mysql function name in the select method call, it returns an error.

Code:

$this->db->select('field1, field2, date_format(date_field_name, "%D/%M/%Y %H:%M") as some_date');

When I checked the query, I can see that the quotes (`) applied for the field names by CI creates problem.

Is there any way to get around this.

Thanks

[eluser]mackerel[/eluser]
select() takes a second argument. If it's FALSE, codeigniter won't quote the select.

[eluser]vigna[/eluser]
Thanks mackerel!