>>>>> "David" == David G Johnston <david.g.johnston@gmail.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)