DATE_SUB()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a date with an INTERVAL expression subtracted.
USAGE
DATE_SUB(date, INTERVAL number unit)
Argument Name | Description |
|---|---|
| The starting date |
| The interval of time to subtract expressed as a count of units |
DETAILS
DATE_SUB() is a date-time function that subtracts an interval of time from a starting date.
An empty string is returned if the unit value is not valid (e.g., if you specified 'days' instead of 'day'.
A NULL is returned if any argument is NULL.
It is recommended that you CAST a string argument to a DATE or DATETIME type to ensure you get the return value you expect.
A similar function is SUB_
EXAMPLES
SELECT DATE_SUB(CAST('2019-01-15' AS DATE), INTERVAL 11 DAY) AS result1,
DATE_SUB(CAST('2019-04-01' AS DATE), INTERVAL 2 YEAR) + 0 AS result2;
+------------+----------+
| result1 | result2 |
+------------+----------+
| 2019-01-04 | 20170401 |
+------------+----------+
SELECT DATE_SUB('2019-01-15 12:34:56.123456', INTERVAL 56 SECOND) AS result;
+----------------------------+
| result |
+----------------------------+
| 2019-01-15 12:34:00.123456 |
+----------------------------+