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

SELECT * FROM  Table name  WHERE to_days( Time field name ) = to_days(now());

SELECT * FROM  Table name  WHERE TO_DAYS(NOW()) - TO_DAYS( Time field name ) <= 1 AND TO_DAYS(NOW()) - TO_DAYS( Time field name ) > 0;

SELECT * FROM  Table name  WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date( Time field name );

SELECT * FROM  Table name  WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date( Time field name );

SELECT * FROM  Table name  WHERE QUARTER( Time field name ) = QUARTER(now());

SELECT * FROM  Table name  WHERE date_format( Time field name ,'%Y-%m') = date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH), '%Y-%m');
SELECT * FROM  Table name  WHERE DATE_FORMAT( Time field name ,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m') ;
SELECT * FROM  Table name  WHERE WEEKOFYEAR(FROM_UNIXTIME( Time field name ,'%y-%m-%d')) = WEEKOFYEAR(now());
SELECT * FROM  Table name  WHERE MONTH(FROM_UNIXTIME( Time field name ,'%y-%m-%d')) = MONTH(now());
SELECT * FROM  Table name  WHERE YEAR(FROM_UNIXTIME( Time field name ,'%y-%m-%d')) = YEAR(now()) and MONTH(FROM_UNIXTIME( Time field name ,'%y-%m-%d')) = MONTH(now());
SELECT * FROM  Table name  WHERE  Time field name  between  Last day of last month  and  The first day of next month ;

DATE_FORMAT(date,format)

date  Parameter is a valid date .format  Specified date / Time output format .

The available formats are ：

example

The following script uses DATE_FORMAT() Function to display different formats . We use NOW() To get the current date / Time ：

DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p')
DATE_FORMAT(NOW(),'%m-%d-%Y')
DATE_FORMAT(NOW(),'%d %b %y')
DATE_FORMAT(NOW(),'%d %b %Y %T:%f')