SQL · Date and time functions

make_date()

Builds a date from parts. PostgreSQL.

sqlRunnable example sql course

Syntax

make_date(year, month, day)

Example

Open in the lab

SELECT date('2026-11-01') AS built;

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