自定义列表调用当天发布的信息
统计:select count(*) as total from [!db.pre!]ecms_news where date(FROM_UNIXTIME(newstime, ‘%Y%m%d’ ))=curdate()
查询:select * from [!db.pre!]ecms_news where date(FROM_UNIXTIME(newstime, ‘%Y%m%d’ ))=curdate()
自定义列表调用当天发布的信息
统计:select count(*) as total from [!db.pre!]ecms_news where date(FROM_UNIXTIME(newstime, ‘%Y%m%d’ ))=curdate()
查询:select * from [!db.pre!]ecms_news where date(FROM_UNIXTIME(newstime, ‘%Y%m%d’ ))=curdate()