SQL · Date and time functions

date modifiers

SQLite modifiers such as start of month, weekday 1 and +3 hours.

sqlRunnable example sql course

Syntax

date(now, 'start of month')

Example

Open in the lab

SELECT date('2026-11-15', 'start of month', '+1 month', '-1 day') AS month_end;

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