SQL · Date and time functions

interval arithmetic

Adds or subtracts an interval. PostgreSQL and MySQL.

sqlRunnable example sql course

Syntax

date + interval '7 days'

Example

Open in the lab

-- PostgreSQL
-- SELECT current_date + interval '7 days';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.