MySQL日期加减

NOW(),CURDATE(),CURTIME()

mysql> SELECT NOW(),CURDATE(),CURTIME();
+---------------------+------------+-----------+
| NOW()               | CURDATE()  | CURTIME() |
+---------------------+------------+-----------+
| 2022-12-26 20:57:30 | 2022-12-26 | 20:57:30  |
+---------------------+------------+-----------+
1 row in set (0.01 sec)

DATE_SUB

指定日期前一天

mysql> select DATE_SUB('2016-08-01',interval 1 day);
+---------------------------------------+
| DATE_SUB('2016-08-01',interval 1 day) |
+---------------------------------------+
| 2016-07-31                            |
+---------------------------------------+
1 row in set (0.00 sec)

当前日期后一天

mysql> select date_sub(CURDATE(),interval -1 day);
+-------------------------------------+
| date_sub(CURDATE(),interval -1 day) |
+-------------------------------------+
| 2022-12-27                          |
+-------------------------------------+
1 row in set (0.00 sec)

当前日期后一月

mysql> select date_sub(CURDATE(),interval -1 month);
+---------------------------------------+
| date_sub(CURDATE(),interval -1 month) |
+---------------------------------------+
| 2023-01-26                            |
+---------------------------------------+
1 row in set (0.00 sec)

当前日期后一年

mysql> select date_sub(CURDATE(),interval -1 year);
+--------------------------------------+
| date_sub(CURDATE(),interval -1 year) |
+--------------------------------------+
| 2023-12-26                           |
+--------------------------------------+
1 row in set (0.00 sec)

参考：mysql 获取当前时间，前一天，后一天