PostgreSQL Function Reference

MAKE_DATE
Creates a date from year, month, and day.
PostgreSQL 17.5
MAKE_DATE(year, month, day)
year
The year
month
The month
day
The day
Examples
PostgreSQL 17.5
SELECT MAKE_DATE(2025, 6, 5)