Date Time Functions MySQL Tutorial

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