SELECT YEAR(CURDATE()) AS 'year',QUARTER(CURDATE()) AS 'quarter',MONTH(CURDATE()) AS 'month',WEEKOFYEAR(CURDATE()) AS 'week',DAYOFYEAR(CURDATE()) AS 'day'
做统计用得到
积累知识，分享知识，学习知识。
bin-pureLife 2016-08-25 15:15 原文
SELECT YEAR(CURDATE()) AS 'year',QUARTER(CURDATE()) AS 'quarter',MONTH(CURDATE()) AS 'month',WEEKOFYEAR(CURDATE()) AS 'week',DAYOFYEAR(CURDATE()) AS 'day'