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
|
Список | 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 по дате отправления: