按日期查询所需数据

查询日期范围

• 关健字 between

SELECT * FROM violatetable WHERE create_time BETWEEN '2020-4-1' and '2020-06-08'

查询当天数据

SELECT * FROM violatetable WHERE DAY(create_time) = DAY(now());

查询当周数据

SELECT * FROM violatetable WHERE week(create_time) = DAY(now());

查询当月数据

SELECT * FROM violatetable WHERE month(create_time) = month(now());

查询当年数据

SELECT * FROM violatetable WHERE YEAR(create_time) = YEAR(now());

具体年月日查询

SELECT * FROM hits WHERE day(create_time)='27';
SELECT * FROM hits WHERE month(create_time)='7';
SELECT * FROM hits WHERE year(create_time)='2020';

X年X月查询

SELECT * FROM hits WHERE year(create_time)='2019' and month(createtime)='6';

查询指定当日数据

• 关健词 date

SELECT * FROM violatetable where DATE(create_time) = '2020-05-13'