mysql 查詢 時間序列資料

USE  SALE;
USE  SALE;
SHOW TABLES;
SHOW COLUMNS FROM SALE_TEMP;
select paydate from sale_temp;
select paydate from sale_temp order by paydate desc limit 1	;
select * from sale_temp where period_diff(date_format(now(),'%Y%m'),date_format(paydate,'%Y%m'))=1
show create table sale_temp
select * from sale_temp order by paydate desc limit 1;
show columns from sale_temp;
select idcard,companysecname from sale_temp where paydate >= '2020-05-01' and paydate <= '2020-06-01';
select paydate from sale_temp where paydate >='2020-05-01' and paydate<='2020-05-02';
select now();
select current_date();
select * from sale_temp where date_format(paydate,'%Y%m%d')=date_format(current_date(),'%Y%m%d');
select * from sale_temp where date_format(paydate,'%Y%m%d')=(date_format(current_date(),'%Y%m%d')-1);
select * from sale_temp where to_days(paydate)=to_days(now());
select * from sale_temp where to_days(paydate)=(to_days(now())-1);
select * from sale_temp where to_days(now())-to_days(paydate)<=7; 
select * from sale_temp where date_sub(current_date(),interval 7 day)<=date(paydate);
select * from sale_temp where date_format(paydate,'%Y%m')=date_format(current_date(),'%Y%m');
select * from sale_temp where period_diff(date_format(current_date(),'%Y%m'),date_format(paydate,'%Y%m'))=1 order by paydate;