DATE_ADD & DATE_SUB

How can we add or subtract specific time intervals from dates?

Intermediate⏱ 3 Minutes⭐ 530 XP

🤔 THE QUESTION

How can we add or subtract specific time intervals from dates?

💡 WHAT IS IT?

DATE_ADD and DATE_SUB add or subtract intervals (days, months, years) from date values.

🎯 WHAT IS IT USED FOR?

Subscription expiry dates, 30-day review cycles, historical SLA lookbacks.

💻 EXAMPLE

SELECT
name,
DATE_ADD(join_date, INTERVAL 30 DAY)
AS review_date
FROM employees;

Practice typing production-grade SQL code for DATE_ADD & DATE_SUB.