[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?