time and timetz

Learning Focus

Use this lesson to understand time and timetz and when you should prefer timestamptz for real event times.

Overview

• time: time of day without date
• timetz: time of day with time zone offset

Most systems prefer timestamptz for events.

Example

CREATE TABLE store_hours (
  store_id bigint PRIMARY KEY,
  opens_at time NOT NULL,
  closes_at time NOT NULL
);

What's Next

• Next: timestamp and timestamptz
• Section Overview