BUG #2908: ISO8601 Date / Time Format Incompatibility

From: "David Lloyd" <lloy0076(at)adam(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2908: ISO8601 Date / Time Format Incompatibility
Date: 2007-01-19 05:55:12
Message-ID: 200701190555.l0J5tC7I003993@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2908
Logged by: David Lloyd
Email address: lloy0076(at)adam(dot)com(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Vogel 2007-01-19 09:31:53 BUG #2910: Setting timestamps to null doesn't work with PDO
Previous Message Adriaan van Os 2007-01-19 05:52:32 BUG #2907: pg_get_serial_sequence quoting