mysql时间戳 按日月_宁国腾|专业分享 站开发-PHP，软件设计博客

create_time时间格式

SELECT DATE_FORMAT(create_time,’%Y%u’) weeks,COUNT(id) COUNT FROM role GROUP BY weeks;

SELECT DATE_FORMAT(create_time,’%Y%m%d’) days,COUNT(id) COUNT FROM role GROUP BY days;

SELECT DATE_FORMAT(create_time,’%Y%m’) months,COUNT(id) COUNT FROM role GROUP BY months

create_time时间戳格式

SELECT FROM_UNIXTIME(create_time,’%Y%u’) weeks,COUNT(id) COUNT FROM role GROUP BY weeks;

SELECT FROM_UNIXTIME(create_time,’%Y%m%d’) days,COUNT(id) COUNT FROM role GROUP BY days;

SELECT FROM_UNIXTIME(create_time,’%Y%m’) months,COUNT(id) COUNT FROM role GROUP BY months

文章知识点与官方知识档案匹配，可进一步学习相关知识MySQL入门技能树内置函数时间日期函数32932 人正在系统学习中 相关资源：全科医学主治医师考试宝典2015v11.0中文免费安装版-其它代码类…