MySQL SUBTIME() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MySQL SUBTIME() Function
❮ MySQL Functions
Example
Subtract 5.000001 seconds and return the datetime:
SELECT SUBTIME("2017-06-15 10:24:21.000004", "5.000001");Try it Yourself »
Definition and Usage
The SUBTIME() function subtracts a time interval from a time/datetime and then returns the
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 |
|---|
More Examples
Example
Subtract 3 hours, 2 minutes, 5.000001 seconds and return the datetime:
SELECT SUBTIME("2017-06-15 10:24:21.000004", "3:2:5.000001");Try it Yourself »
Example
Subtract 5 seconds and return the time:
SELECT SUBTIME("10:24:21", "5");Try it Yourself »
Example
Add 3 hours, 2 minutes, and 5 seconds, and return the time:
SELECT SUBTIME("10:24:21", "-3:2:5");Try it Yourself »
❮ MySQL Functions
