mysql> select now(); +---------------------+ | now() | +---------------------+ | 2019-08-04 20:03:11 | +---------------------+ 1 row in set (0.00 sec) mysql> select date_add(now(),interval 2 day); +--------------------------------+ | date_add(now(),interval 2 day) | +--------------------------------+ | 2019-08-06 20:02:51 | +--------------------------------+ 1 row in set (0.00 sec)
定义和用法
DATE_ADD() 函数向日期添加指定的时间间隔。
语法
DATE_ADD(date,INTERVAL expr type)
date 参数是合法的日期表达式。expr 参数是您希望添加的时间间隔。
type 参数可以是下列值：
| Type 值 |
|---|
| MICROSECOND |
| SECOND |
| MINUTE |
| HOUR |
| DAY |
| WEEK |
| MONTH |
| QUARTER |
| YEAR |
| SECOND_MICROSECOND |
| MINUTE_MICROSECOND |
| MINUTE_SECOND |
| HOUR_MICROSECOND |
| HOUR_SECOND |
| HOUR_MINUTE |
| DAY_MICROSECOND |
| DAY_SECOND |
| DAY_MINUTE |
| DAY_HOUR |
| YEAR_MONTH |
参考：