查询当天数据(mysql)

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

posted @ 2016-06-24 17:49  rickon  阅读(201)  评论(0编辑  收藏  举报