Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' - Mailing list pgsql-patches

From Tom Lane
Subject Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date
Msg-id 29711.1063052239@sss.pgh.pa.us
Whole thread Raw
In response to Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'  ("Ron Mayer" <ron@intervideo.com>)
Responses Re: ISO 8601 'Time Intervals' of the 'format with time-unit  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
"Ron Mayer" <ron@intervideo.com> writes:
> Would it be useful if I added a 'datestyle' of 'ISO basic' which
> would produce the most terse formats ('19980115' for dates,
> and 'P1Y1M' for intervals)?

I don't really care for using that name for it --- for one thing, you
couldn't do
    set datestyle to iso basic;
because of syntax limitations.  A one-word name is a much better idea.

Perhaps call it "compact" or "terse" datestyle?


> PS: What's the best inexpenive way for me to know if this changed
> at all between the final draft and the published standard?

ANSI sells PDFs of ISO specs at their online store
http://webstore.ansi.org/ansidocstore/default.asp
although it looks like they want $81 for 8601, which is not my idea of
"inexpensive".

Usually ISO final drafts differ very little from the published specs;
I think you could just work from the draft and no one would complain.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Next
From: Bruce Momjian
Date:
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit