Skip to content

timestamp-with-timezone-with-precision (TP003)#

Automatic fix is available.

What it does#

Checks for usage of timestamp with time zone with precision.

Why not?#

Because it rounds off the fractional part rather than truncating it as everyone would expect. This can cause unexpected issues; consider that when you store now() into such a column, you might be storing a value half a second in the future.

When should you?#

Never.

Use instead:#

timestamptz (also known as timestamp with time zone) without precision.