Home > mailing lists

Timestamp with precision output format with trailing zeros - Mailing list pgsql-general

From	Eugene Podshivalov
Subject	Timestamp with precision output format with trailing zeros
Date	January 7, 2022 23:04:39
Msg-id	CAEPw1JUdXkwJjWi4JWE-MWT-mmkpKfmtRLSCSoBCTHdNK-y3qQ@mail.gmail.com Whole thread Raw
List	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

From: Rob Sargent
Date: 07 January 2022, 21:27:44
Subject: Re: java.lang.ClassNotFoundException: batchprint.Batch

From: Allie Crawford
Date: 08 January 2022, 00:57:28
Subject: Stream Replication not working