Articles/SQL

DATE_ADD() in MySQL — How It Works

What the MySQL DATE_ADD() function does, with an example.

Published October 19, 2026

DATE_ADD() adds a specified time interval to a date.

Key points

  • Part of standard SQL functions available in MySQL for working with dates and times

Example

SELECT DATE_ADD(NOW(), INTERVAL 7 DAY);
More SQL articles