SELECT * FROM apple ORDER BY id DESC LIMIT 1;
select * from apple where to_days(data_time) = to_days(now());
select * from apple where to_days(NOW()) - TO_DAYS(data_time) <= 1;
select * from apple where date_sub(CURDATE(),INTERVAL 7 DAY) <= DATE(data_time);
SELECT * FROM apple where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(data_time);
SELECT * FROM apple WHERE DATE_FORMAT( data_time, '%Y%m' ) = DATE_FORMAT( CURDATE() , '%Y%m' );
SELECT * FROM apple WHERE PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format( data_time, '%Y%m' ) ) =1;
select * FROM apple where QUARTER(data_time)=QUARTER(now());
select * FROM apple where QUARTER(data_time)=QUARTER(DATE_SUB(now(),interval 1 QUARTER));
select * FROM apple where YEAR(data_time)=YEAR(NOW());