Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT TIMESTAMPADD(MONTH,1,2003-01-02)
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)