| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Ron Mayer <ron(at)intervideo(dot)com>, <andrew(at)dunslane(dot)net>, <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: ISO 8601 'Time Intervals' of the 'format with time-unit |
| Date: | 2003-09-08 21:58:09 |
| Message-ID: | Pine.LNX.4.44.0309082357070.1015-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
Tom Lane writes:
> "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.
iso8601
Keep in mind that SQL itself is also a kind of ISO, so being more specific
is useful.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:06:11 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| Previous Message | Ron Johnson | 2003-09-08 21:40:16 | Re: About GPL and proprietary software |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:01:02 | Re: why does count take so long? |
| Previous Message | Greg Stark | 2003-09-08 21:55:43 | Re: Can I use PostgreSQL to develop a self-organizing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:06:11 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| Previous Message | Jeroen Ruigrok/asmodai | 2003-09-08 21:55:11 | Re: FreeBSD/i386 thread test |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:06:11 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| Previous Message | Greg Stark | 2003-09-08 21:47:37 | Re: [PATCHES] mcxt.c |