SELECT TIMESTAMPADD(YEAR,1,'2003-01-02'); : TIMESTAMPADD « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. TIMESTAMPADD
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>








14.46.TIMESTAMPADD
14.46.1.TIMESTAMPADD(unit,interval,datetime_expr) adds the integer expression interval to datetime_expr
14.46.2.SELECT TIMESTAMPADD(SECOND,1,'2003-01-02');
14.46.3.SELECT TIMESTAMPADD(FRAC_SECOND,1,'2003-01-02');
14.46.4.SELECT TIMESTAMPADD(HOUR,1,'2003-01-02');
14.46.5.SELECT TIMESTAMPADD(DAY,1,'2003-01-02');
14.46.6.SELECT TIMESTAMPADD(WEEK,1,'2003-01-02');
14.46.7.SELECT TIMESTAMPADD(MONTH,1,'2003-01-02');
14.46.8.SELECT TIMESTAMPADD(QUARTER,1,'2003-01-02');
14.46.9.SELECT TIMESTAMPADD(YEAR,1,'2003-01-02');