BUG #2908: ISO8601 Date / Time Format Incompatibility

Поиск
Список
Период
Сортировка
От David Lloyd
Тема BUG #2908: ISO8601 Date / Time Format Incompatibility
Дата
Msg-id 200701190555.l0J5tC7I003993@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2908: ISO8601 Date / Time Format Incompatibility  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2908
Logged by:          David Lloyd
Email address:      lloy0076@adam.com.au
PostgreSQL version: 8.1
Operating system:   Solaris 10
Description:        ISO8601 Date / Time Format Incompatibility
Details:

According to the ISO standard, 8601:

--
Fractions may also be used with any of the three time elements. These are
indicated by using the decimal point (either a comma (which is preferred) or
dot).
--

http://en.wikipedia.org/wiki/ISO_8601

[Follow the links to one of the PDF standards from there]

However, inserting such a value gives an error:

lloy0076=# create table tstest(t timestamp);
CREATE TABLE
lloy0076=# insert into tstest values('2006-01-01 10:00:00,5');
ERROR:  invalid input syntax for type timestamp: "2006-01-01 10:00:00,5"
lloy0076=# in

Notice the "invalid" input syntax.

Thanks,

DSL

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Aravind"
Дата:
Сообщение: BUG #2912: postgres database connectivity
Следующее
От: Milton César de Souza Leite
Дата:
Сообщение: PostgreSQL & Slackware