MySQL queries the SQL code for the data of this week, last week, this month, and last month.

MySQL queries the SQL code for the data of this week, last week, this month, and last month.

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