mysql将时间戳转换为年月日格式进行查询

转换为年月日格式进行查询"/>

mysql将时间戳转换为年月日格式进行查询

  create_time时间格式SELECT DATE_FORMAT(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days;
create_time时间戳格式SELECT FROM_UNIXTIME(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days;
举例：
<!--	查询主管最近30天注册用户数   -->SELECT DATE_FORMAT(a.create_time, '%Y%m%d') AS days, COUNT(*) AS userCountFROM sssss aWHERE  a.dept_id = 1AND a.create_time >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)AND a.recommender_user_id IN (SELECT DISTINCT b.recommender_user_idFROM sssssss  bJOIN ssssss c ON b.recommender_user_id = c.user_idWHERE c.distri_user_id = #{userId})GROUP BY days;