timestampadd

description

Syntax

DATETIME TIMESTAMPADD(unit, interval, DATETIME datetime_expr)

将整数表达式间隔添加到日期或日期时间表达式datetime_expr中。

interval的单位由unit参数给出，它应该是下列值之一:

SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, or YEAR。

example

2. mysql> SELECT TIMESTAMPADD(MINUTE,1,'2019-01-02');
3. +------------------------------------------------+
4. | timestampadd(MINUTE, 1, '2019-01-02 00:00:00') |
5. +------------------------------------------------+
6. | 2019-01-02 00:01:00                            |
7. +------------------------------------------------+

9. mysql> SELECT TIMESTAMPADD(WEEK,1,'2019-01-02');
10. +----------------------------------------------+
11. | timestampadd(WEEK, 1, '2019-01-02 00:00:00') |
12. +----------------------------------------------+
13. | 2019-01-09 00:00:00                          |
14. +----------------------------------------------+

keywords

1. TIMESTAMPADD