C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
| MySQL DATE_ADD() FunctionThe date_add() is a MySQL date/time function. It is used to get the date in which some date/datetime intervals are added. Syntax
 select date_add(date, interval value unit); Parameter:
 Date: date in which interval will be added Value: date/time intervals Unit: type of interval which are as following: 
 | MICROSECOND | 4.1.1+ | SECOND | 3.2.3+ | MINUTE | 3.2.3+ | HOUR | 3.2.3+ | DAY | 3.2.3+ | WEEK | 5+ | MONTH | 3.2.3+ | QUARTER | 5+ | YEAR | 3.2.3+ | SECOND_MICROSECOND | 4.1.1+ | MINUTE_MICROSECOND | 4.1.1+ | MINUTE_SECOND | 4.1.1+ | HOUR_MICROSECOND | 4.1.1+ | HOUR_SECOND | 4.1.1+ | HOUR_MINUTE | 3.2.3+ | DAY_MICROSECOND | 4.1.1+ | DAY_SECOND | 3.2.3+ | DAY_MINUTE | 3.2.3+ | DAY_HOUR | 3.2.3+ | YEAR_MONTH | 3.2.3+ |