MySQL DATE_ADD Function

The MySQL DATE_ADD function adds a custom time interval to a date.

Employees Table

In this example, we want to find out what year the employees’ are eligible for retirement.

Syntax

DATE_ADD(date,INTERVAL interval format)

Format

• MICROSECOND
• SECOND
• MINUTE
• HOUR
• DAY
• WEEK
• MONTH
• QUARTER
• YEAR
• SECOND_MICROSECOND
• MINUTE_MICROSECOND
• MINUTE_SECOND
• HOUR_MICROSECOND
• HOUR_SECOND
• HOUR_MINUTE
• DAY_MICROSECOND
• DAY_SECOND
• DAY_MINUTE
• DAY_HOUR
• YEAR_MONTH

Example

SELECT employeeName as [Employee Name], DATE_ADD(hireDate INTERVAL 30 YEAR) as [Retirement Year]
FROM employees

Results