Javatpoint Logo
Javatpoint Logo

MySQL DATE_ADD() Function

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

Syntax

Parameter:

Date: date in which interval will be added

Value: date/time intervals

Unit: type of interval which are as following:

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 will return a date after which a certain time/date interval has been added.

Example


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




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA