How to add a time value to a datetime value using the TIMESTAMP() function?

TIMESTAMP(datetime, time) is a MySQL built-in function that adds a time value to a datetime value. For example:

SELECT TIMESTAMP('2023-12-31 12:00:00', '12:00:00');
  -- +---------------------------------------------+
  -- | TIMESTAMP('2023-12-31 12:00:00','12:00:00') |
  -- +---------------------------------------------+
  -- | 2024-01-01 00:00:00                         |
  -- +---------------------------------------------+

SELECT TIMESTAMP('2023-12-31 12:00:00', '-48:00:00');
  -- +-----------------------------------------------+
  -- | TIMESTAMP('2023-12-31 12:00:00', '-48:00:00') |
  -- +-----------------------------------------------+
  -- | 2023-12-29 12:00:00                           |
  -- +-----------------------------------------------+

Reference information of the TIMESTAMP() function:

TIMESTAMP(datetime, time): dt
   Adds the second argument as a time value to the first argument
   and returns the result as a datetime value.

Arguments, return value and availability:
  datetime: Required. The timestamp to be subtracted from.
  time: Optional. Default is '00:00:00'. The time value to be subtracted.
  dt: Return value. The updated timestamp.
  Available since MySQL 4.

Related MySQL functions:

• TIMEDIFF() - Difference of Two Timestamps

⇒ TIMESTAMPADD() - Incrementing Timestamp

⇐ TIMEDIFF() - Difference of Two Timestamps

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References