SQL · Date and time functions

strftime()

Formats a date using codes such as %Y, %m, %d and %H.

sqlRunnable example sql course

Syntax

strftime(format, timestring)

Example

Open in the lab

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

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