mysql查询判断今天或昨天/今日今年等方法 Thinkphp的FROM_UNIXTIME及DATEDIFF用法示例

SELECT count(*) FROM @#_member WHERE DATEDIFF(now(),FROM_UNIXTIME(time))=0 ;//等于0表示查今天的记录,1表示昨天等

Thinkphp 写法示例

$sql="SELECT count(*) as c FROM `tg_list` WHERE DATEDIFF(now(),FROM_UNIXTIME(ctime))=0  ";
$result = M()->query($sql);
$this->assign('count2', $result[0]['c']);//模板读取 {$count2}