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. Syntaxselect 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+ |