Thinkphp3.1query method time format processing skills

Query in thinkphp3.1 cannot pre-process the time format. Now we provide a tip for writing. Pass % Y-% m-% d into the SQL statement as the variable. Do not write it directly; otherwise, an error is returned. $ Sqlselect * from (select * fromy_awhereanddatatimebetween % dand % dorderbydatatimedesc) asAgroupb

Query in thinkphp3.1 cannot pre-process the time format. Now we provide a tip for writing. Pass % Y-% m-% d into the SQL statement as the variable. Do not write it directly; otherwise, an error is returned. $ SQL = "select * from (select * from y_a where id = '% s' and datatime between % d and % d order by datatime desc) as A group B

Query in thinkphp3.1 cannot pre-process the time format. Now we provide a tip for writing. Pass % Y-% m-% d into the SQL statement as the variable. Do not write it directly; otherwise, an error is returned.

 $sql=" select * from (select * from y_a where id='%s' and datatime between %d and %d order by datatime desc) as A group by from_unixtime(datatime,'%s') order by datatime ASC limit 30";        $data=$this->query($sql,array($xywy_userid,$starttime,$endtime,'%Y-%m-%d'));