Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. TIMESTAMPADD is like ADDDATE, but it uses a different syntax for specifying the interval
mysql>
mysql> select TIMESTAMPADD(DAY, 5, '2005-12-31');
+------------------------------------+
| TIMESTAMPADD(DAY, 5, '2005-12-31') |
+------------------------------------+
| 2006-01-05                         |
+------------------------------------+
1 row in set (0.00 sec)