| 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 22:39:44 |
| Message-ID: | Pine.LNX.4.44.0309090032220.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:
> Yes, but by the same token "iso8601" isn't specific enough either.
> Several of the other input formats we support have at least as good a
> claim on that name.
The only input formats we support are along the lines of
@ 1 year 2 mons 3 days 4 hours 5 mins 6 secs
@ 1 year 2 mons 3 days 04:05:06
These are also the supported output formats (the first you get for 'sql',
'postgres', and 'german' formats; the second is 'iso'). A quick check of
ISO 8601 shows, however, that neither of these are close to anything
specified in that standard.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:45:03 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| Previous Message | Tom Lane | 2003-09-08 22:06:11 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:45:03 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| Previous Message | Karsten Hilbert | 2003-09-08 22:37:44 | Re: Can I use PostgreSQL to develop a self-organizing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:40:23 | Re: constraint modification on todo list |
| Previous Message | Bruce Momjian | 2003-09-08 22:36:07 | Re: FreeBSD/i386 thread test |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-08 22:45:03 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
| Previous Message | Tom Lane | 2003-09-08 22:26:01 | Re: [PATCHES] mcxt.c |