DATE_ADD() Function in MySQL

Last Updated : 25 Nov, 2020

DATE_ADD() function in MySQL is used to add a specified time or date interval to a specified date and then return the date.

Syntax:

DATE_ADD(date, INTERVAL value addunit)

Parameter: This function accepts two parameters which are illustrated below:

date –
Specified date to be modified.
value addunit –
Here the value is the date or time interval to add. This value can be both positive and negative. And here the addunit is the type of interval to add such as SECOND, MINUTE, HOUR, DAY, YEAR, MONTH, etc.

Returns :

It returns the new date after the addition of a specified time or date.

Example 1:

Getting a new date of “2020-11-22” after the addition of 3 years to the specified date “2017-11-22”.

SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);

Output:

2020-11-22

Example 2:

Getting a new date of “2020-11-22” after the addition of 2 months to the specified date “2020-9-22”.

SELECT DATE_ADD("2020-9-22", INTERVAL 2 MONTH);

Output:

2020-11-22

Example 3:

Getting a new date of “2020-11-22” after the addition of 10 days to the specified date “2020-11-12”.

SELECT DATE_ADD("2020-11-12", INTERVAL 10 DAY);

Output:

2020-11-22

Example 4:

Getting a new date of “2020-11-22 09:12:10” after the addition of 3 hours to the specified date “2020-11-22 06:12:10”.

SELECT DATE_ADD("2020-11-22 06:12:10", INTERVAL 3 HOUR);

Output:

2020-11-22 09:12:10

Example 5:

Getting a new date of “2020-11-22 09:09:10” after the addition of 3 minutes to the specified date “2020-11-22 09:06:10”.

SELECT DATE_ADD("2020-11-22 09:06:10", INTERVAL 3 MINUTE);

Output:

2020-11-22 09:09:10

Example 6:

Getting a new date of “2020-11-22 09:09:10” after the addition of 5 seconds to the specified date “2020-11-22 09:09:5”.

SELECT DATE_ADD("2020-11-22 09:09:5", INTERVAL 5 SECOND);

Output:

2020-11-22 09:09:10

DATEDIFF() Function in MySQL

Kanchan_Ray

Improve

Article Tags :

SQL
mysql

Similar Reads

ADDDATE() function in MySQL

The ADDDATE() function in MySQL is a powerful tool for adding specific time intervals to date or datetime values. It simplifies data manipulation by allowing us to easily calculate future or adjusted dates based on a given starting point. In this article, we will learn about the ADDDATE() function i

3 min read

CURDATE() Function in MySQL

The CURDATE() function in MYSQL is used to return the current date. The date is returned to the format of "YYYY-MM-DD" (string) or as YYYYMMDD (numeric). This function equals the CURRENT_DATE() function. In this article, we are going to discuss about CURDATE() function in detail. Syntax CURDATE(); P

2 min read

UTC_DATE() function in MySQL

UTC_DATE() function in MySQL is used to check current Coordinated Universal Time (UTC) date. It returns the UTC date value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context. Syntax : UTC_DATE OR UTC_DATE() Parameter : This method does not acce

2 min read

DAY() Function in MySQL

DAY() function : This function in MySQL is used to return the day of the month for a specified date (a number from 1 to 31). This function equals the DAYOFMONTH() function. Syntax : DAY(date) Parameter : This method accepts a parameter which is illustrated below : date : Specified date to extract th

1 min read

DATEDIFF() Function in MySQL

DATEDIFF() function in MySQL is used to return the number of days between two specified date values. Syntax: DATEDIFF(date1, date2) Parameter: This function accepts two parameters as given below: date1: First specified datedate2: Second specified date Returns : It returns the number of days between

2 min read

MySQL ADDTIME() function

MySQL ADDTIME() function adds the specified time intervals to the given date and time. It returns the date or DateTime value after adding the time interval. SyntaxThe MySQL ADDTIME() function syntax is: ADDTIME(expr1, expr2) ParameterADDTIME() function accepts two parameters. expr1: The given dateti

2 min read

CURRENT_DATE() Function in MySQL

In this article, you will see how you can use the current_date function and you will see both formats in the string and numeric respectively. CURRENT_DATE : In this function, you will see how you can use the current date function. In MSQSSL, format of date 'â€˜YYYY-MM-DDâ€™(in string) format or YYYYMMDD

1 min read

DAYNAME() Function in MySQL

DAYNAME() function : This function in MySQL is used to return the weekday name for a specified date. Syntax : DAYNAME(date) Parameter : This method accepts a parameter which is illustrated below as follows. date - Specified date to extract the weekday name from Returns : It returns the weekday name

1 min read

COT() Function in MySQL

COT() function : This function in MySQL is used to return the cotangent of a specified number. If the specified number is 0, an error or NULL will be returned. In a right triangle, the cotangent of an angle is the length of it's adjacent side divided by the length of the opposite side. Similarly, th

1 min read

STR_TO_DATE() function in MySQL

STR_TO_DATE() : This function in MySQL helps to convert string values to date or time or DateTime values. The function will return zero (0000-00-00) if an empty string is passed as an argument. Syntax : STR_TO_DATE(string, format) Parameters : string -The string which will be converted to DateTime.

2 min read