Skip to content

time-with-time-zone (TP002)#

Automatic fix is available.

What it does#

Checks for usage of time with time zone.

Why not?#

Even the manual tells you it is only implemented for SQL compliance:

The type time with time zone is defined by the SQL standard, but the definition exhibits properties which lead to questionable usefulness. In most cases, a combination of date, time, timestamp without time zone, and timestamp with time zone should provide a complete range of date/time functionality required by any application.

When should you?#

Never.

Use instead:#

timestamptz (also known as timestamp with time zone).