In mysql, SQL queries are performed on the current day, yesterday, this month, and quarter.

This article has added a collection of SQL statements for query on the current day, yesterday, this month, and the quarter in mysql. For more information, see.

This article has added a collection of SQL statements for query on the current day, yesterday, this month, and the quarter in mysql. For more information, see.

The Code is as follows:

Query Today Select * from table name where to_days (time field name) = to_days (now ()); Yesterday SELECT * FROM table name WHERE TO_DAYS (NOW ()-TO_DAYS (time field name) <= 1 7 days SELECT * FROM table name where DATE_SUB (CURDATE (), INTERVAL 7 DAY) <= date (time field name) Last 30 days SELECT * FROM table name where DATE_SUB (CURDATE (), INTERVAL 30 DAY) <= date (time field name) This month SELECT * FROM table name WHERE DATE_FORMAT (time field name, '% Y % m') = DATE_FORMAT (CURDATE (),' % Y % m ') Last month SELECT * FROM table name WHERE PERIOD_DIFF (date_format (now (), '% Y % m'), date_format (time field name,' % Y % m') = 1 At the same time, attach a mysql Official document # Querying data for the current quarter Select * from 'ht _ invoice_information' where QUARTER (create_date) = QUARTER (now ()); # Querying data of the last quarter Select * from 'ht _ invoice_information' where QUARTER (create_date) = QUARTER (DATE_SUB (now (), interval 1 QUARTER )); # Querying current year data Select * from 'ht _ invoice_information 'where YEAR (create_date) = YEAR (NOW ()); # Querying data of the previous year Select * from 'ht _ invoice_information 'where year (create_date) = year (date_sub (now (), interval 1 year )); Query data for the current week SELECT name, submittime FROM enterprise where yearweek (date_format (submittime, '% Y-% m-% D') = YEARWEEK (now ()); Query last week's data SELECT name, submittime FROM enterprise where yearweek (date_format (submittime, '% Y-% m-% D') = YEARWEEK (now ()-1; Query data of the current month Select name, submittime from enterprise where date_format (submittime, '% Y-% m') = date_format (now (),' % Y-% m ') Query data 6 months from the current time Select name, submittime from enterprise where submittime between date_sub (now (), interval 6 month) and now (); Query data of last month Select name, submittime from enterprise where date_format (submittime, '% Y-% m') = date_format (DATE_SUB (curdate (), INTERVAL 1 MONTH ), '% Y-% m ') Select * from 'user' where DATE_FORMAT (pudate, '% Y % m') = DATE_FORMAT (CURDATE (),' % Y % m '); Select * from user where WEEKOFYEAR (FROM_UNIXTIME (pudate, '% y-% m-% D') = WEEKOFYEAR (now ()) Select * From user Where MONTH (FROM_UNIXTIME (pudate, '% y-% m-% D') = MONTH (now ()) Select * From [user] Where YEAR (FROM_UNIXTIME (pudate, '% y-% m-% D') = YEAR (now ()) And MONTH (FROM_UNIXTIME (pudate, '% y-% m-% D') = MONTH (now ()) Select * From [user] Where pudate between last day of last month And the first day of next month Where date (regdate) = curdate (); Select * from test where year (regdate) = year (now () and month (regdate) = month (now () and day (regdate) = day (now ()) SELECT date (c_instime), curdate () FROM't _ score' WHERE 1 LIMIT 0, 30 Http://dev.mysql.com/doc/refman/5.1/zh/tutorial.html