SQL · String functions

printf()

Formats numbers and strings with printf-style placeholders. Very useful for padding in SQLite.

sqlRunnable example sql course

Syntax

printf(format, …values)

Example

Open in the lab

SELECT printf('%03d', 7) AS padded;

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