Example
SELECT ADDTIME("2017-06-15
09:34:21", "2");Definition and Usage
The ADDTIME() function adds a time interval to a time/datetime and then returns the time/datetime.
Syntax
ADDTIME(
datetime
,
addtime
)Parameter Values
| Parameter | Description |
|---|---|
| datetime | Required. The time/datetime to be modified |
| addtime | Required. The time interval to add to datetime . Both positive and negative values are allowed |
Technical Details
| Works in: | From MySQL 4.0 |
|---|