从数据库查最近有关日期方面的语句

查询最近七天的数据

SELECT DATE_FORMAT( 字段名, '%y-%m-%d' ) days,count(*) count
FROM( SELECT * FROM 表名 WHERE DATE_SUB( CURDATE( ), INTERVAL 7 DAY ) <= date( 字段名) ) as time
GROUP BY days;

 

查看今年四个季度的数据

SELECT QUARTER(时间字段) as quartername ,
FROM 表名
GROUP BY quartername