Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15389: Fill zero in milliseconds of a timestamp - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15389: Fill zero in milliseconds of a timestamp
Date
Msg-id 1282311537271961@sas2-ce04c18c415c.qloud-c.yandex.net
Whole thread Raw
In response to BUG #15389: Fill zero in milliseconds of a timestamp  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15389: Fill zero in milliseconds of a timestamp
List pgsql-bugs
Tree view 
Hello

> I don't think is correct because if I try to convert in Java become 099.
"2014-09-26 17:17:45.099"?
I think Java is incorrect here. Usually trailing zeros can be omitted.
Also postgresql timestamp has resolution 1 microsecond, so with trailing zeros it must be "2014-09-26 17:17:45.990000",
not"2014-09-26 17:17:45.990".
 

regards, Sergei

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15389: Fill zero in milliseconds of a timestamp
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15389: Fill zero in milliseconds of a timestamp