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

From Peter Eisentraut
Subject Re: ISO 8601 'Time Intervals' of the 'format with time-unit
Date
Msg-id Pine.LNX.4.44.0309082357070.1015-100000@peter.localdomain
Whole thread Raw
In response to Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
List pgsql-patches
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


pgsql-patches by date:

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