PostgreSQL

timetz stores meaningless time-only values with timezone offset

warning
configurationUpdated Mar 4, 2026
Technologies:
How to detect:

timetz (time with time zone) stores time of day with timezone offset, but a timezone offset without a date is meaningless because daylight saving time rules depend on the date. A time zone offset for '3:00 PM' is ambiguous without knowing which day. PostgreSQL documentation states timetz exists only for SQL standard compliance.

Recommended action:

Use timestamptz for storing points in time. For time-of-day values (like 'store opens at 9:00 AM'), use time (without timezone) and handle timezone conversions in your application.