Date Time Functions MySQL Tutorial

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