MySQL queries data of the current day, this week, last week, this month, and last month.

Query records of the current day

Select * From hb_article_view where to_days (hb_addtime) = to_days (now ())

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