MySQL Tutorial/Date Time Functions/TIMESTAMPADD

SELECT TIMESTAMPADD(DAY,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMPADD(DAY,1,"2003-01-02"); +----------------------------------+ | TIMESTAMPADD(DAY,1,"2003-01-02") | +----------------------------------+ | 2003-01-03 | +----------------------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT TIMESTAMPADD(FRAC_SECOND,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> mysql> SELECT TIMESTAMPADD(FRAC_SECOND,1,"2003-01-02"); +------------------------------------------+ | TIMESTAMPADD(FRAC_SECOND,1,"2003-01-02") | +------------------------------------------+ | 2003-01-02 00:00:00.000001 | +------------------------------------------+ 1 row in set (0.00 sec)</source>

SELECT TIMESTAMPADD(HOUR,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMPADD(HOUR,1,"2003-01-02"); +-----------------------------------+ | TIMESTAMPADD(HOUR,1,"2003-01-02") | +-----------------------------------+ | 2003-01-02 01:00:00 | +-----------------------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT TIMESTAMPADD(MONTH,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> mysql> SELECT TIMESTAMPADD(MONTH,1,"2003-01-02"); +------------------------------------+ | TIMESTAMPADD(MONTH,1,"2003-01-02") | +------------------------------------+ | 2003-02-02 | +------------------------------------+ 1 row in set (0.00 sec)</source>

SELECT TIMESTAMPADD(QUARTER,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMPADD(QUARTER,1,"2003-01-02"); +--------------------------------------+ | TIMESTAMPADD(QUARTER,1,"2003-01-02") | +--------------------------------------+ | 2003-04-02 | +--------------------------------------+ 1 row in set (0.00 sec) mysql></source>

SELECT TIMESTAMPADD(SECOND,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMPADD(SECOND,1,"2003-01-02"); +-------------------------------------+ | TIMESTAMPADD(SECOND,1,"2003-01-02") | +-------------------------------------+ | 2003-01-02 00:00:01 | +-------------------------------------+ 1 row in set (0.00 sec)</source>

SELECT TIMESTAMPADD(WEEK,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMPADD(WEEK,1,"2003-01-02"); +-----------------------------------+ | TIMESTAMPADD(WEEK,1,"2003-01-02") | +-----------------------------------+ | 2003-01-09 | +-----------------------------------+ 1 row in set (0.00 sec)</source>

SELECT TIMESTAMPADD(YEAR,1,"2003-01-02");

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMPADD(YEAR,1,"2003-01-02"); +-----------------------------------+ | TIMESTAMPADD(YEAR,1,"2003-01-02") | +-----------------------------------+ | 2004-01-02 | +-----------------------------------+ 1 row in set (0.00 sec) mysql></source>

TIMESTAMPADD(unit,interval,datetime_expr) adds the integer expression interval to datetime_expr

The unit for interval is given by the unit argument.

The unit value may be specified with a prefix of SQL_TSI_.

For example, DAY and SQL_TSI_DAY both are legal.

The unit should be one of the following values:

1. FRAC_SECOND,
2. SECOND,
3. MINUTE,
4. HOUR,
5. DAY,
6. WEEK,
7. MONTH,
8. QUARTER, or
9. YEAR.

   <source lang="sql">

mysql> mysql> mysql> SELECT TIMESTAMPADD(MINUTE,1,"2003-01-02"); +-------------------------------------+ | TIMESTAMPADD(MINUTE,1,"2003-01-02") | +-------------------------------------+ | 2003-01-02 00:01:00 | +-------------------------------------+ 1 row in set (0.02 sec)</source>