数据库中以年/月/日为单位查询数量
所用语句:SELECT DATE_FORMAT(create_time, "%Y-%m-%d" ) AS datetimes,COUNT(*) FROM location_community WHERE DATE_FORMAT(create_time, "%Y-%m-%d" ) BETWEEN '2012-10-10' AND '2016-05-05' GROUP BY DATE_FORM
原创
2016-04-12 09:51:17 ·
452 阅读 ·
0 评论