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
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 |