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.