我插入数据库的日期格式是时间戳,
select count(1) from edian_member where opencardstore=4 and TO_DAYS(FROM_UNIXTIME( opencardtime, '%Y%m%d' ))=TO_DAYS(NOW())
如果插入的日期格式就需要转化
select count(1) from edian_member where opencardstore=4 and TO_DAYS(opencardtime)=TO_DAYS(NOW())