做统计用得到

SELECT YEAR(CURDATE()) AS 'year',QUARTER(CURDATE()) AS 'quarter',MONTH(CURDATE()) AS 'month',WEEKOFYEAR(CURDATE()) AS 'week',DAYOFYEAR(CURDATE()) AS 'day'

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/bin-pureLife/p/5806935.html