mysql 时间格式转换（时间函数的使用）

--  时间格式转换 ,获取当前的时间
SELECT DATE_FORMAT(NOW(), '%Y%m')

SELECT IFNULL(submit_month,"2021汇总"),COUNT(ymd),ROUND(COUNT(ymd)/max(ymd),3)
FROM
(
SELECT  CONCAT(
SUBSTRING_INDEX(SUBSTRING_INDEX(submit_time,'-',2),'-',1),
SUBSTRING_INDEX(SUBSTRING_INDEX(submit_time,'-',2),'-',-1)) AS submit_month,
-- 获取一个月最后一天 
DAYOFMONTH(LAST_DAY(submit_time)) as ymd 
FROM practice_record WHERE YEAR(submit_time)=2021
) a 
GROUP BY submit_month
-- ROLLUP 生成的结果集显示了所选列中值的某一层次结构的聚合
with ROLLUP

使用时间格式转换

SELECT IFNULL(submit_month,"2021汇总"),COUNT(ymd),ROUND(COUNT(ymd)/max(ymd),3)
FROM
(
SELECT  DATE_FORMAT(submit_time, '%Y%m')  AS submit_month,
-- 获取一个月最后一天 
DAYOFMONTH(LAST_DAY(submit_time)) as ymd 
FROM practice_record WHERE YEAR(submit_time)=2021
) a 
GROUP BY submit_month
-- ROLLUP 生成的结果集显示了所选列中值的某一层次结构的聚合
with ROLLUP