Collections:
SUBTIME() - Subtracting Time
How to subtract a time interval from a given date or time value using the SUBTIME() function?
✍: FYIcenter.com
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:
⇒ SYSDATE() - Current Timestamp
⇐ SUBDATE() - Synonym for DATE_SUB()
2023-11-17, 258🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...