SQL Date Functions Date Arithmetic

The SQL Date functions allow you to manipulate and perform operations on date and time data types. One of these functions is Date Arithmetic, which allows you to perform calculations and operations on dates.

Syntax

The syntax for the SQL Date Arithmetic function is:

SELECT date_add(date, INTERVAL value unit) 

Example

Let's consider an example where we want to add a month to the current date. The SQL statement for this would be:

SELECT DATE_ADD(CURDATE(), INTERVAL 1 MONTH);

Here, the DATE_ADD function adds a month to the current date (CURDATE()) using the INTERVAL keyword and MONTH as the unit.

Output

The output for the above SQL statement is as follows:

2022-08-28

Explanation

The DATE_ADD function adds the specified interval to the date and returns the result. In our example, we are adding a month to the current date (CURDATE()) using the INTERVAL keyword and MONTH as the unit.

Use

The SQL Date Arithmetic function is useful when you need to perform calculations or manipulations on date and time data. You can use this function to add or subtract a specified interval from a date or time data type.

Important Points

• The unit parameter can be any of the following: MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR.
• The value parameter can be any integer.
• The DATE_ADD function returns a date value, which can be formatted or manipulated further using other date functions.

Summary

The SQL Date Arithmetic function allows you to perform calculations and operations on date and time data types. It is useful when you need to add or subtract a specified interval from a date or time data. The function takes two parameters: value and unit, and returns a date value that can be further manipulated using other date functions. The unit parameter can be any of the following: MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR.