自己答了
select count(id) as cc from posts where timer>(UNIX_TIMESTAMP(CURRENT_DATE())) and timer<(UNIX_TIMESTAMP(CURRENT_DATE())+86400)select count(id) as cc from posts where timer>UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day)) and timer<(UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day))+86400)来接分吧
select count(id) as cc from posts where timer>(UNIX_TIMESTAMP(CURRENT_DATE())) and timer<(UNIX_TIMESTAMP(CURRENT_DATE())+86400)select count(id) as cc from posts where timer>UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day)) and timer<(UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day))+86400)来接分吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货