Subtract an interval

sql

SELECT DATE_SUB(NOW(), INTERVAL 30 DAY) AS thirty_days_ago;

Explanation

Handy for rolling windows and recent-activity filters.

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 future date or time.

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.