SQL · Date and time functions

to_char()

Formats a timestamp with a picture string. PostgreSQL.

sqlRunnable example sql course

Syntax

to_char(timestamp, format)

Example

Open in the lab

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

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