SQL · Date and time functions

date()

Returns a date, optionally adjusted by modifiers such as +7 days.

sqlRunnable example sql course

Syntax

date(timestring, modifier, …)

Example

Open in the lab

SELECT date('2026-11-01', '+7 days') AS next_week;

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