php - SELECT FROM_UNIXTIME(created, `'%Y-%m-%d'` ) AS day

Question

$this->db->select("FROM_UNIXTIME(created, '%Y-%m-%d' )  AS day")

......

The result of

ci is:

SELECT FROM_UNIXTIME(created, `'%Y-%m-%d'` ) AS day

How to avoid mysql’s timestamp function by adding the `` symbol

Answer 1

Can you try escaping the single quotes

Answer 2

    
    $this->db->select('FROM_UNIXTIME(created, "%Y-%m-%d" )  AS day');

Answer 3

$this->db->select("from_unixtime(created,'%Y-%m-$d') as day",false)

Add false parameter