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.