From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Ron Mayer" <ron(at)intervideo(dot)com> |
Cc: | andrew(at)dunslane(dot)net, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
Date: | 2003-09-08 20:17:19 |
Message-ID: | 29711.1063052239@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
"Ron Mayer" <ron(at)intervideo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-09-08 20:25:21 | Re: About GPL and proprietary software |
Previous Message | Tom Lane | 2003-09-08 19:59:20 | Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators" |
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2003-09-08 20:22:45 | Re: Can I use PostgreSQL to develop a self-organizing database system? |
Previous Message | Tom Lane | 2003-09-08 19:59:20 | Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators" |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-09-08 20:27:16 | Re: ISO 8601 "Time Intervals" of the "format with time-unit |
Previous Message | Bruce Momjian | 2003-09-08 20:10:51 | Re: pgsql vc++|win32 |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-09-08 20:27:16 | Re: ISO 8601 "Time Intervals" of the "format with time-unit |
Previous Message | Tom Lane | 2003-09-08 19:59:20 | Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators" |