1.获取昨天日期
SELECT DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) as yesterday
2.获取当前日期
SELECT CURRENT_DATE() as today
3.获取明天日期
SELECT DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY) as tomorrow
1.获取昨天日期
SELECT DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) as yesterday
2.获取当前日期
SELECT CURRENT_DATE() as today
3.获取明天日期
SELECT DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY) as tomorrow