↑↓ select ↵ open ⌫ change scope Open full search

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

Extensions / Data types

timestampandtz

C data type that stores a timestamp together with its source time-zone identity, with casts, operators, indexing, and date/time functions.

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagetimestampandtz
Version1.0.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Schemapg_catalog
Stars21
Latest commit2025-12-29
Latest release2018-06-25
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pgautAuto Update Timestamp for PostgreSQL
temporalC extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support.