Add an interval to a date

sql

SELECT DATE_ADD(NOW(), INTERVAL 7 DAY) AS one_week_from_now;

Explanation

Common in expiration, scheduling, and retention logic.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing date and time functions

Calculate a relative date in the past.

Open In sheetsqlsame section

Return current timestamp values.

Open In sheetsqlsame section

Render a datetime using format specifiers.

Open In sheetsqlsame section

Calculate age or duration.

Open In sheetsqlsame section

Read a path inside a JSON document.

Write or replace a value inside a JSON document.