使用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()
;

查询出的结果如下

按十分钟维度统计数据

SELECT 
	DATE_FORMAT(
		CONCAT(
		DATE(NOW()),
		' ',
		HOUR(NOW()),
		':',
	FLOOR(MINUTE(NOW())/10)*10),/*向下取整*/
		'%Y-%m-%d %H:%i') 
	AS TenMinute;

查询后的结果如下

三种计算今天是这年的第几周的方法

SELECT 
WEEK(date_add(substring(NOW(),1,10),INTERVAL 6 DAY),2) AS WEEK,
WEEK(NOW(),1),
WEEKOFYEAR(NOW())
;

查询结果如下