做统计用得到

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

posted @ 2016-08-25 15:15  鱼尾纹  阅读(113)  评论(0)    收藏  举报