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

Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

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 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-09-08 20:27:16
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit
Previous:From: Bruce MomjianDate: 2003-09-08 20:10:51
Subject: Re: pgsql vc++|win32

pgsql-patches by date

Next:From: Bruce MomjianDate: 2003-09-08 20:27:16
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit
Previous:From: Tom LaneDate: 2003-09-08 19:59:20
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

pgsql-advocacy by date

Next:From: Bruce MomjianDate: 2003-09-08 20:25:21
Subject: Re: About GPL and proprietary software
Previous:From: Tom LaneDate: 2003-09-08 19:59:20
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

pgsql-general by date

Next:From: Karsten HilbertDate: 2003-09-08 20:22:45
Subject: Re: Can I use PostgreSQL to develop a self-organizing database system?
Previous:From: Tom LaneDate: 2003-09-08 19:59:20
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

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