使用MySQL进行日期的统计
按照日期维度统计
SELECT
YEARWEEK(NOW(),1),
YEAR(NOW()),
DATE(NOW()),
REPLACE(SUBSTRING(NOW(),1,7),'-','') AS YEARMONTH,
MONTHNAME(NOW()),
MONTH(NOW()),
WEEK(NOW(),1),
WEEKOFYEAR(NOW()),
NOW()
;
查询出的结果如下
按十...
原创
2019-05-15 10:15:43 ·
589 阅读 ·
0 评论