make_date ( year int, month int, day int ) → dateCreate date from year, month and day fields (negative years signify BC)
make_date(2013, 7, 15) → 2013-07-15
FUNCTIONS / DATE/TIME FUNCTIONS AND OPERATORS
make_date
Read PG 18 manual ↗Create date from year, month and day fields (negative years signify BC)
Signatures & examples
Version history 3
- PG 13 → 14changed
- PG 12 → 13changed
- PG 9.3 → 9.4added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source