SQL · Date and time functions

datetime()

Returns a full timestamp, optionally adjusted.

sqlRunnable example sql course

Syntax

datetime(timestring, modifier)

Example

Open in the lab

SELECT datetime('2026-11-01', 'start of month') AS start;

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