DATE_SUB()
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Functions
Topics on this page:
Overview
Performs an arithmetic operation on the given date, subtracting the interval expression by the given units.
See also: Functions in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
EXAMPLES
SELECT DATE_SUB('2019-01-15',INTERVAL 2 YEAR);
+----------------------------------------+
| DATE_SUB('2019-01-15',INTERVAL 2 YEAR) |
+----------------------------------------+
| 2017-01-15 |
+----------------------------------------+
CHANGE HISTORY
Release Series | History |
---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the DATE_SUB() page in the SkySQL Documentation.