TIMESTAMPADD is like ADDDATE, but it uses a different syntax for specifying the interval : TIMESTAMPADD « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. TIMESTAMPADD

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)

   
    
    
    
  

Related examples in the same category