Re: ISO 8601 'Time Intervals' of the 'format with time-unit
Peter Eisentraut <peter_e@gmx.net>
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ron Mayer <ron@intervideo.com>, <andrew@dunslane.net>, <pgsql-patches@postgresql.org>
Date: 2003-09-08T21:58:09Z
Lists: pgsql-hackers
Tom Lane writes:
> "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.
iso8601
Keep in mind that SQL itself is also a kind of ISO, so being more specific
is useful.
--
Peter Eisentraut peter_e@gmx.net