MySQL Query day, this week, this month, the last one months of data

Today

Select *  from where = To_days (now ());

Yesterday

SELECT *  from WHERE - <= 1

Nearly 7 days

SELECT *  from where 7  Day <= Date (Time field name)

Nearly 30 days

SELECT *  from where  -  Day <= Date (Time field name)

Month

SELECT *  from WHERE ' %y%m ' = ' %y%m ' )

Last month

SELECT *  from WHERE ' %y%m ' ' %y%m ' = 1

Query this quarterly data

Select *  from where QUARTER (create_date)=QUARTER (now ());

Query last quarter data

Select *  from where QUARTER (create_date)=1 QUARTER));

Query this year's data

Select *  from where  Year (create_date) =  Year (now ());

Query last year data

Select *  from where  Year (create_date) =  Year 1 year));

Querying data for the current week

SELECT  from WHERE Yearweek (Date_format (submittime,'%y-%m-%d'= Yearweek (now ());

Query last week's data

SELECT  from WHERE Yearweek (Date_format (submittime,'%y-%m-%d'= Yearweek (now ())-  1;

Querying data for the previous month

SelectName,submittime fromEnterprisewhereDate_format (Submittime,'%y-%m')=Date_format (Date_sub (Curdate (), INTERVAL1 MONTH),'%y-%m')Select *  from User whereDate_format (Pudate,'%y%m')=Date_format (Curdate (),'%y%m') ; Select *  from User whereWeekOfYear (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 wherePudatebetweenLast day of last month andThe first day of next month

Querying data for the current month

Select  from Enterprise   where date_format (submittime,'%y-%m')= Date_format (now (),'%y-%m')

Query data that is currently 6 months from now

Select  from where between 6 Month  and now ();

MySQL Query day, this week, this month, the last one months of data