DATE_ADD()

Concepts: sqlDateAdd

Adding Time Intervals Adding Days The most common use case is adding days to calculate due dates or deadlines: Different Time Units Subtracting Time Negative Amounts Use negative amounts to subtract time and look backward: Negative values move backward in time. This is essential for historical analysis, comparing year-over-year metrics, and calculating retention windows. Best Practices When to Use DATE_ADD() Here are the most common scenarios where date arithmetic is needed.