Обсуждение: BUG #2908: ISO8601 Date / Time Format Incompatibility

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

David Lloyd wrote:
> According to the ISO standard, 8601:

The date/time input format in PostgreSQL is determined by the SQL
standard, not ISO 8601.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/