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