USE my_tutorial;
SELECT CURDATE();
SELECT CURDATE() - INTERVAL 1 DAY as yesterday,
CURDATE() as today,
CURDATE() + INTERVAL 1 DAY as tomorrow; 
SELECT CURDATE() - INTERVAL 1 MONTH as Previous_month,
CURDATE() as today,
CURDATE() + INTERVAL 1 MONTH as Next_month; 

SELECT DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH, '%Y-%m-01') as first_day;

SELECT DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH, '%Y-%m-01') as first_day,
LAST_DAY(CURDATE()-INTERVAL 1 MONTH) as last_day;

SELECT DATE_FORMAT(CURDATE() + INTERVAL 2 MONTH, '%Y-%m-01') as first_day,
LAST_DAY(CURDATE() + INTERVAL 2 MONTH) as last_day;