How to increment a component of timestamp value using the TIMESTAMPADD() function?

TIMESTAMPADD(unit, interval, datetime) is a MySQL built-in function that updates a timestamp by incrementing a component. For example:

SELECT TIMESTAMPADD(MINUTE, 1, '2023-01-02');
  -- +---------------------------------------+
  -- | TIMESTAMPADD(MINUTE, 1, '2023-01-02') |
  -- +---------------------------------------+
  -- | 2023-01-02 00:01:00                   |
  -- +---------------------------------------+

SELECT TIMESTAMPADD(MINUTE, -1, '2023-01-02');
  -- +----------------------------------------+
  -- | TIMESTAMPADD(MINUTE, -1, '2023-01-02') |
  -- +----------------------------------------+
  -- | 2023-01-01 23:59:00                    |
  -- +----------------------------------------+

SELECT TIMESTAMPADD(WEEK, 1, '2023-02-28');
  -- +-------------------------------------+
  -- | TIMESTAMPADD(WEEK, 1, '2023-02-28') |
  -- +-------------------------------------+
  -- | 2023-03-07                          |
  -- +-------------------------------------+

SELECT TIMESTAMPADD(MONTH, 1, '2023-03-31');
  -- +--------------------------------------+
  -- | TIMESTAMPADD(MONTH, 1, '2023-03-31') |
  -- +--------------------------------------+
  -- | 2023-04-30                           |
  -- +--------------------------------------+

Reference information of the TIMESTAMPADD() function:

TIMESTAMPADD(unit, interval, datetime): moddate
  Adds the integer expression interval to the timestamp expression
  datetime. The unit for interval is given by the unit argument,
  which should be one of the following values: MICROSECOND,
  SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR.

Arguments, return value and availability:
  unit: Required. The timestamp component unit keyword.
  interval: Required. The integer value to increment by.
  datetime: Required. The starting timestamp.
  moddate: Return value. The incremented timestamp.
  Available since MySQL 4.0.

Related MySQL functions:

• DATE_ADD() - Adding Date/Time Interval

⇒ TIMESTAMPDIFF() - Difference in Timestamp Component

⇐ TIMESTAMP() - Adding Time to Timestamp

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References