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

Поиск
Список
Период
Сортировка
Искать
От
Andrew Gierth
Тема
Re: BUG #15389: Fill zero in milliseconds of a timestamp
Дата
Msg-id
87o9cvhr8k.fsf@news-spur.riddles.org.uk
Ответ на
Re: BUG #15389: Fill zero in milliseconds of a timestamp (David G. Johnston)
Список
Дерево обсуждения
BUG #15389: Fill zero in milliseconds of a timestamp PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15389: Fill zero in milliseconds of a timestamp Sergei Kornilov <sk@zsrv.org>
Re: BUG #15389: Fill zero in milliseconds of a timestamp "David G. Johnston" <david.g.johnston@gmail.com>
Re: BUG #15389: Fill zero in milliseconds of a timestamp Andrew Gierth <andrew@tao11.riddles.org.uk> 
>>>>> "David" == David G Johnston  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)
В списке pgsql-bugs по дате отправления
Предыдущее
От: David G. Johnston
Дата:
Следующее
От: Peter J. Holzer
Дата:
FAQ