↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

make_date

Create date from year, month and day fields (negative years signify BC)

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
datetime
group label
时间/日期函数和操作符
lang
en
layout
table-new
pages
functions-datetime.html
prose only
false

Definition PG 18

Create date from year, month and day fields (negative years signify BC)

Signatures and overloads

make_date ( year int, month int, day int ) → date → date
Create date from year, month and day fields (negative years signify BC)

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-datetime.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"8c5053713aeaacfbe4cb00effc61f10d457c98b2a29c724b10b93819a087ea95","version":"18.7"},{"file":"functions-datetime.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"c3efdd1c3df6795c73dfea2ecec17ca31ff37da23d758083a581d75445851f0c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:8b8c8d91d40cc2631ebb073638ca07b06c8c14015076d7f96e92c6c6954b3b53

Text language: en · wiki-repair-20261023:8b8c8d91d40cc2631ebb073638ca07b06c8c14015076d7f96e92c6c6954b3b53