DB->SELECT error

[eluser]LAMP Coder[/eluser]

Code:

$this->db->select("FROM_UNIXTIME(entered_on,'%M/%D/%Y') AS invoiceDate");

Above code ends up in an error because CI converts the query to following:

Code:

SELECT FROM_UNIXTIME(entered_on, `'%M/%D/%Y')` AS invoiceDate FROM (`invoices`) WHERE...

how do i get around this?

[eluser]n0xie[/eluser]

Code:

$this->db->select("FROM_UNIXTIME(entered_on,'%M/%D/%Y') AS invoiceDate", FALSE);

[eluser]LAMP Coder[/eluser]
thank you