查询当天数据(mysql)

SELECT count(*) as nums FROM go_member_share WHERE DATEDIFF(FROM_UNIXTIME(time, '%Y-%m-%d') , now()) = 0

原文地址:https://www.cnblogs.com/rickons/p/5614978.html