HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
MySQL Functions : Add 10 days to a date and return the date
The DATE_ADD() function adds a time/date interval to a date and then returns the date.
DATE_ADD(date, INTERVAL value addunit)
Parameter | Description |
---|---|
date | Required. The date to be modified |
value | Required. The value of the time/date interval to add. Both positive and negative values are allowed |
addunit | Required. The type of interval to add. Can be one of the following
values:
|
Works in: | From MySQL 4.0 |
---|
Add 15 minutes to a date and return the date:
SELECT DATE_ADD("2017-06-15 09:34:21", INTERVAL 15 MINUTE);
Subtract 3 hours to a date and return the date:
SELECT DATE_ADD("2017-06-15 09:34:21", INTERVAL -3 HOUR);
Subtract 2 months to a date and return the date:
SELECT DATE_ADD("2017-06-15", INTERVAL -2 MONTH);