There are many ways to query MySQL. The MySQL query Implementation described below is to query data from this week, last week, this month, and last month. If you are interested in MySQL query, take a look
There are many ways to query MySQL. The MySQL query Implementation described below is to query data from this week, last week, this month, and last month. If you are interested in MySQL query, take a look
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
