Javatpoint Logo
Javatpoint Logo

MySQL ADDDATE() Function

The adddate() is a MySQL date/time function. It is used to get the date in which some time/date intervals are added.

Syntax

Or

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.

Unit compatibility
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+

Returns:

This function returns the date in which some time/date intervals are added.

Example:

MySQL ADDDATE() Function
MySQL ADDDATE() Function
MySQL ADDDATE() Function
MySQL ADDDATE() Function
MySQL ADDDATE() Function
Next TopicMySQL date/time




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA