默认第一天是周日(日,1,2,3,4,5,6)
select date_sub(yourDate,INTERVAL if((WEEKDAY(yourDate) +1)=7,0,WEEKDAY(yourDate) +1) DAY) ;
例如:
select date_sub('2020-09-13',INTERVAL if((WEEKDAY('2020-09-13') +1)=7,0,WEEKDAY('2020-09-13') +1) DAY) ;
默认第一天是周日(日,1,2,3,4,5,6)
select date_sub(yourDate,INTERVAL if((WEEKDAY(yourDate) +1)=7,0,WEEKDAY(yourDate) +1) DAY) ;
例如:
select date_sub('2020-09-13',INTERVAL if((WEEKDAY('2020-09-13') +1)=7,0,WEEKDAY('2020-09-13') +1) DAY) ;