Date and Time Data Types

📄️ date

Use PostgreSQL date for calendar dates without time, understand comparisons, and pick correct semantics.

Use PostgreSQL time and timetz for time-of-day values and understand when timestamps are more appropriate.

Choose between PostgreSQL timestamp and timestamptz, understand time zone semantics, and avoid production time bugs.

Use PostgreSQL interval for durations, time arithmetic, and scheduling logic.