Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group