Skip to content
Opensource internals
  • Posts

Date

PostgreSQL's date Implementation in C

Jul 27, 2026 5 min read Jay Hubbert

A PostgreSQL date is not a Unix timestamp, not a struct tm, and not “days since 1970”. It is a signed 32-bit integer counting days since 2000-01-01. That single decision is why a …

PostgresInternalsDate

Read more →

© 2026 Jay Hubbert · Built with Hugo 0.168.0

RSS ·