How to subtract a time interval from a given date or time value using the SUBTIME() function?

SUBTIME(time, expr) is a MySQL built-in function that subtracts a time interval from a given date or time value. For example:

SELECT SUBTIME('2022-03-01 23:59:59.999999','1 1:1:1.000002');
  -- +--------------------------------------------------------+
  -- | SUBTIME('2022-03-01 23:59:59.999999','1 1:1:1.000002') |
  -- +--------------------------------------------------------+
  -- | 2022-02-28 22:58:58.999997                             |
  -- +--------------------------------------------------------+

SELECT SUBTIME('01:00:00.999999', '02:00:00.999998');
  -- +-----------------------------------------------+
  -- | SUBTIME('01:00:00.999999', '02:00:00.999998') |
  -- +-----------------------------------------------+
  -- | -00:59:59.999999                              |
  -- +-----------------------------------------------+

Reference information of the SUBTIME() function:

SUBTIME(expr1, expr2): modtime
  Subtracts expr2 from expr1 and returns the result. expr1 is a time or datetime
  expression, and expr2 is a time expression.

Arguments, return value and availability:
  expr1: Required. The starting time to be subtracted from.
  expr2: Required. The time interval to be subtracted.
  modtime: Return value. The updated time.
  Available since MySQL 4.0.

Related MySQL functions:

• ADDTIME() - Adding Time

⇒ SYSDATE() - Current Timestamp

⇐ SUBDATE() - Synonym for DATE_SUB()

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References