make_date ( year int, month int, day int ) → date → dateCreate date from year, month and day fields (negative years signify BC)
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
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