Create timestamp with time zone from year, month, day, hour, minute and seconds fields (negative years signify BC). If timezone is not specified, the current time zone is used; the examples assume the session time zone is Europe/London
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
timezone is not specified, the current time zone is used; the examples assume the session time zone is Europe/Londonmake_timestamptz ( year int, month int, mday int, hour int, min int, sec double precision [, timezone text] ) → timestamp with time zone → timestamp with time zoneCreate timestamp with time zone from year, month, day, hour, minute and seconds fields (negative years signify BC). If
timezone is not specified, the current time zone is used; the examples assume the session time zone is Europe/London{"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"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:b1b7c76433250c8ab8350558c7c871e16f373a0aa2d9cb378e0ace0d97bdac66
Text language: en · wiki-repair-20261023:b1b7c76433250c8ab8350558c7c871e16f373a0aa2d9cb378e0ace0d97bdac66