查询当天数据(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  阅读(220)  评论(0)    收藏  举报