Re: BUG #15389: Fill zero in milliseconds of a timestamp

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "taddeoluca96(at)gmail(dot)com" <taddeoluca96(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15389: Fill zero in milliseconds of a timestamp
Date: 2018-09-18 11:59:21
Message-ID: 1282311537271961@sas2-ce04c18c415c.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2018-09-18 13:17:00 Re: BUG #15389: Fill zero in milliseconds of a timestamp
Previous Message PG Bug reporting form 2018-09-18 11:44:15 BUG #15389: Fill zero in milliseconds of a timestamp