MySQL SUBTIME() Function

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 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

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

Subtract 3 minutes and return the time:

SELECT SUBTIME("10:24:21", "300");
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 »

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.