| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Sergei Kornilov <sk(at)zsrv(dot)org>, "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 13:30:10 |
| Message-ID: | 87o9cvhr8k.fsf@news-spur.riddles.org.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
>>>>> "David" == David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
>> 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".
David> Except the decimal in that construct is a simple part separator
David> and not a fractional indicator.
Both the SQL spec and ISO 8601 beg to differ.
--
Andrew (irc:RhodiumToad)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2018-09-18 16:36:53 | Re: BUG #15388: time convert error when use AT TIME ZONE '+8' |
| Previous Message | David G. Johnston | 2018-09-18 13:17:00 | Re: BUG #15389: Fill zero in milliseconds of a timestamp |