C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL ADDDATE() FunctionThe adddate() is a MySQL date/time function. It is used to get the date in which some time/date intervals are added. Syntaxselect adddate(date, interval value unit ); Or select adddate(date, days); Parameters:Date: date to be added in intervals Days: number of days to be added in date Value: value of date/time is upto the user. Positive and negative values can be given. Unit: it is unit type of interval.
| 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+ |