SQL · Functions and expressions

extract()

Reads a field from a date or timestamp. SQLite uses strftime().

sqlRunnable example sql course

Syntax

extract(year from date)

Example

Open in the lab

SELECT strftime('%Y', '2026-11-01') AS year;

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