1 / 8

PostgreSQL · Joins & aggregations

Choose a type for the concept

Use date for a calendar day. Use timestamp without time zone for a wall-clock value whose zone is intentionally external. Use timestamptz for a real instant that should be comparable across zones. Use interval for a duration or calendar-relative span.

PostgreSQL converts timestamptz input to UTC internally and displays it in the session time zone. The original zone name is not stored. For future appointments in a named location, keep the location's zone separately if the local wall time itself matters.