{"id":11464,"date":"2023-10-22T17:33:51","date_gmt":"2023-10-23T00:33:51","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11464"},"modified":"2023-10-22T17:40:11","modified_gmt":"2023-10-23T00:40:11","slug":"mysql-timestampadd","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-timestampadd\/","title":{"rendered":"MySQL TIMESTAMPADD() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL TIMESTAMPADD()<\/code> function to add or subtract intervals from a timestamp or date.<\/p>\n\n\n\n

Introduction to MySQL TIMESTAMPADD() function<\/h2>\n\n\n\n

The TIMESTAMPADD()<\/code> function allows you to add or subtract intervals from a timestamp<\/a> or date<\/a>.<\/p>\n\n\n\n

Here’s the syntax of the TIMESTAMPADD()<\/code> function:<\/p>\n\n\n

TIMESTAMPADD(unit, interval, timestamp)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n
    \n
  • unit<\/code>: This is the unit of time that you want to add (e.g., SECOND<\/code>, MINUTE<\/code>, HOUR<\/code>, DAY<\/code>, WEEK<\/code>, MONTH<\/code>, YEAR<\/code>).<\/li>\n\n\n\n
  • interval<\/code>: This is the number of intervals you want to add (can be a positive or negative integer).<\/li>\n\n\n\n
  • timestamp<\/code>: This is the timestamp or date to which you want to add the interval.<\/li>\n<\/ul>\n\n\n\n
    The TIMESTAMPADD()<\/code> function returns a new date or timestamp with the new.<\/p>\n\n\n\n
    It returns NULL<\/code> if interval<\/code> or timestamp<\/code> is NULL<\/code>.<\/p>\n\n\n\n
    MySQL TIMESTAMPADD() function examples<\/h2>\n\n\n\n
    Let’s take some examples of using the MySQL TIMESTAMPADD()<\/code> function.<\/p>\n\n\n\n
    1) Basic usage of TIMESTAMPADD() function example<\/h3>\n\n\n\n
    The following example uses the TIMESTAMPADD()<\/code> function to add days to a given timestamp:<\/p>\n\n\n
    SELECT<\/span> \n  TIMESTAMPADD<\/span>(DAY<\/span>, 7<\/span>, '2023-10-19 15:30:00'<\/span>) AS<\/span> new_timestamp<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +---------------------+<\/span>\n| new_timestamp       |\n+---------------------+<\/span>\n| 2023-10-26 15:30:00 |\n+---------------------+<\/span>\n1 row in set<\/span> (0.01<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    In this example, we use the TIMESTAMPADD<\/code>() function to add seven days to the timestamp '2023-10-19 15:30:00'<\/code>.<\/p>\n\n\n\n
    2) Using TIMESTAMPADD() with different intervals<\/h3>\n\n\n\n
    The following example uses the TIMESTAMPADD()<\/code> function to add three months to the date  '2022-07-15'<\/code>:<\/p>\n\n\n
    SELECT<\/span> \n  TIMESTAMPADD<\/span>(MONTH<\/span>, 3<\/span>, '2022-07-15'<\/span>) AS<\/span> new_date;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +------------+<\/span>\n| new_date   |\n+------------+<\/span>\n| 2022-10-15 |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the TIMESTAMPADD()<\/code> function to add or subtract intervals from a timestamp or date.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful? <\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t