Skip to content
Opensource internals
  • Posts

Timestamp

PostgreSQL's timestamp and timestamptz Implementation in C

Oct 6, 2026 7 min read Jay Hubbert

Here is the punchline up front: in PostgreSQL, timestamp and timestamptz are the same value. Both are an 8-byte signed integer counting microseconds since 2000-01-01. The type …

PostgresInternalsTimestampTimestamptz

Read more →

© 2026 Jay Hubbert · Built with Hugo 0.168.0

RSS ·