Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4115: PostgreSQL ISO format is not really ISO - Mailing list pgsql-bugs

From Daniel Ruoso
Subject Re: BUG #4115: PostgreSQL ISO format is not really ISO
Date
Msg-id 1208641920.24675.4.camel@pitombeira
Whole thread Raw
In response to Re: BUG #4115: PostgreSQL ISO format is not really ISO  ("Jaime Casanova" <systemguards@gmail.com>)
Responses Re: BUG #4115: PostgreSQL ISO format is not really ISO  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Tree view 
Sáb, 2008-04-19 às 12:10 -0500, Jaime Casanova escreveu:
> """
> Unlike the previous examples, "2007-04-05 14:30" is considered two
> separate, but acceptable, representations—one for date and the other
> for time. It is then left to the reader to interpret the two separate
> representations as meaning a single time point based on the context.
> """

On the other hand, some important ISO8601-based specifications only
accept the dateTtime notation, for instance XML Schema.

As I was talking on #postgresql, I think it would be nice to have that
output option as one of the date/time output styles (name it ISO8601 or
ISO-strict), and it really doesn't need to be the default (the way pg
uses it now is nice for the human reader).

daniel

pgsql-bugs by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: BUG #4115: PostgreSQL ISO format is not really ISO
Next
From: Sam Mason
Date:
Subject: Re: Inconsistent shift operator