Skip to content
masterclass Buddy
Start learning

PostgreSQL · Type Alias

timestamptz

PostgreSQL accepts local timestamps that fall in daylight-saving gaps or repeats. It resolves them by choosing a UTC offset, but an explicit offset or abbreviation can select the intended instant.

Last updated

Syntax

'local timestamp'::timestamptz

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • timestamptz
  • TimeZone
  • UTC offset
  • daylight-saving time
  • timestamp input

Source: PostgreSQL: Documentation: 18: B.2. Handling of Invalid or Ambiguous Timestamps. Checked 2026-11-03.