Timestamp with precision output format with trailing zeros

From: Eugene Podshivalov <yaugenka(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Timestamp with precision output format with trailing zeros
Date: 2022-01-07 20:04:39
Message-ID: CAEPw1JUdXkwJjWi4JWE-MWT-mmkpKfmtRLSCSoBCTHdNK-y3qQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
>
> # select '2022-01-06 18:00:00.000+03'::timestamptz(3);
> timestamptz
> ------------------------
> 2022-01-06 18:00:00+03

Would it be more correct to output zero milliseconds if the column has
precision defined?

Regards,
Eugene

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allie Crawford 2022-01-07 21:57:28 Stream Replication not working
Previous Message Rob Sargent 2022-01-07 18:27:44 Re: java.lang.ClassNotFoundException: batchprint.Batch