Postgres Pro
Downloads
Home   >   mailing lists

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

From Daniel Ruoso
Subject BUG #4115: PostgreSQL ISO format is not really ISO
Date
Msg-id 200804191138.m3JBcOcg043355@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4115: PostgreSQL ISO format is not really ISO
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      4115
Logged by:          Daniel Ruoso
Email address:      daniel@ruoso.com
PostgreSQL version: 8.3.1
Operating system:   Debian GNU/Linux lenny
Description:        PostgreSQL ISO format is not really ISO
Details:

ISO8601[1] defines Date/Time ouput, and is, today, quite accepted, being the
standard used by XML Schema definitions. Which means that they have to be in
that format to be accepted by a XML validator.

The basic difference between PostgreSQL format and the ISO format is the
absence of a "T" between the date and the time.

[1] http://en.wikipedia.org/wiki/ISO_8601

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inconsistent shift operator
Next
From: "Graham Leggett"
Date:
Subject: BUG #4116: Cannot create tablespace: could not set permissions on directory