make_timestamp

Create timestamp from year, month, day, hour, minute and seconds 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

9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

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

Definition PG 18

Create timestamp from year, month, day, hour, minute and seconds fields (negative years signify BC)

Signatures and overloads

make_timestamp ( year int, month int, mday int, hour int, min int, sec double precision ) → timestamp → timestamp

Create timestamp from year, month, day, hour, minute and seconds 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

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:efc1fecd08c214ef0e40120aab90262c77bc434d15083e0d03debd266016505c

Text language: en · wiki-repair-20261023:efc1fecd08c214ef0e40120aab90262c77bc434d15083e0d03debd266016505c