Beginner

269. DATEADD Function

Learn how to add a specified time interval to a date.

📘 Lesson 269 of 728 ⏱ 10 min 🎯 Intermediate

DATEADD is commonly used in SQL Server to add a specified number of units such as days, months, or years to a date.

Adding time intervals is essential for calculating due dates, future periods, deadlines, and rolling reporting windows.

Calculate a payment due date 30 days after a transaction.

SQL 
SELECT
    TransactionDate,
    DATEADD(day, 30, TransactionDate) AS DueDate
FROM Transactions;

DATEADD is useful for loan schedules, payment deadlines, subscription periods, SLA calculations, and date-based reporting.

  • DATEADD adds time intervals.
  • It is commonly associated with SQL Server.
  • Days, months, and years can be added.
  • It is useful for due-date calculations.
  • Other databases use different date-add functions.
What does DATEADD do?

DATEADD adds a specified number of date or time units to a date.

Where is DATEADD commonly used?

It is commonly used for due dates, deadlines, subscriptions, SLAs, and future date calculations.

Have you finished this lesson?

Introduction to SQL – All Lessons