SELECT DAYOFWEEK('2020-09-30'); SELECT DAYOFWEEK(CURDATE()); SELECT DAYOFWEEK(NOW()); SELECT DAYOFWEEK(CURDATE()- INTERVAL 1 DAY); SELECT DAYOFWEEK(CURDATE()+ INTERVAL 1 DAY); SELECT DAYOFWEEK(CURDATE()- INTERVAL 1 DAY) as yesterday, DAYOFWEEK(CURDATE()) as today, DAYOFWEEK(CURDATE()+ INTERVAL 1 DAY) as tomorrow; SELECT DAYOFWEEK('2020-02-30');