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

Question

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

......

Das Ergebnis von

ci ist:

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

So vermeiden Sie das Hinzufügen des „“-Symbols zur Zeitstempelfunktion von MySQL

Answer 1

你試下轉義單引號行不行

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)

加 false 参数