Example
SELECT SUBTIME("2017-06-15 10:24:21.000004", "5.000001");Definition and Usage
The SUBTIME() function subtracts time from a time/datetime expression and then returns the new time/datetime.
Syntax
SUBTIME(
datetime
,
time_interval
)Parameter Values
| Parameter | Description |
|---|---|
| datetime | Required. The time or datetime to be modified |
| time_interval | Required. The time interval to subtract from datetime . Both positive and negative values are allowed |
Technical Details
| Works in: | From MySQL 4.0 |
|---|