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

Re: ISO8601 nitpicking

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ISO8601 nitpicking
Date: 2012-02-24 18:40:04
Message-ID: CAAZKuFZ-Oju=py0dP-i=mkAXup-p4nD8HGGzbDGrYBBg=MQ4WA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Feb 24, 2012 at 4:45 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On tor, 2012-02-23 at 23:41 -0800, Daniel Farina wrote:
>> As it turns out, evidence would suggests that the "ISO" output in
>> Postgres isn't, unless there's an ISO standard for date and time that
>> is referring to other than 8601.
>
> Yes, ISO 9075, the SQL standard.  This particular issue has been
> discussed many times; see the archives.
>

I did try searching, but this did not come up quickly, except as "the
T is not necessary," as is commonly repeated on the web. The manual is
misleading to me on this admittedly very fine point:

"""
8.5.2. Date/Time Output

The output format of the date/time types can be set to one of the four
styles ISO 8601, SQL (Ingres), traditional POSTGRES (Unix date
format), or German. The default is the ISO format. (The SQL standard
requires the use of the ISO 8601 format. The name of the "SQL" output
format is a historical accident.) Table 8-14 shows examples of each
output style. The output of the date and time types is of course only
the date or time part in accordance with the given examples.

Table 8-14. Date/Time Output Styles

Style Specification	Description	Example
ISO	ISO 8601/SQL standard	1997-12-17 07:37:16-08
"""

If the SQL standard *also*, in fact, refers to ISO 8601 (rather than
defining a format or extension in in ISO 9075), then sans picking a
tiny detail out of the standard I think my point still stands.  I
would appreciate an archive link that hashes this out, if it has been
sifted down into oblivion by search technology.

-- 
fdr

In response to

Responses

pgsql-hackers by date

Next:From: Ants AasmaDate: 2012-02-24 19:23:00
Subject: Re: Patch: add timing of buffer I/O requests
Previous:From: Peter EisentrautDate: 2012-02-24 18:26:03
Subject: Re: proposal: copybytea command for psql

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