From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Randolf Richardson <rr(at)8x(dot)ca> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: ISO 8601 'Time Intervals' of the 'format with time-unit |
Date: | 2003-12-09 23:28:20 |
Message-ID: | 200312092328.hB9NSKt18747@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
Randolf Richardson wrote:
> [sNip]
> > ISO 8601 gives more specific names.
> >
> > ISO 8601 Basic Format: P2Y10M15DT10H20M30S
> > ISO 8601 Alternative Format: P00021015T102030
> > ISO 8601 Extended Format: P0002-10-15T10:20:30
> >
> > In a way, the Extended Format is kinda nice, since its
> > almost human readable.
> >
> > I could put in both the basic and extended ones, and
> > call the dateformats iso8601basic and iso8601extended.
> > The negative is that to do iso8601basic right, Id also
> > have to tweak the date and time parts of the code too.
>
> Perhaps all three formats should be supported, and if the following
> names were all valid things could be simplified further too:
>
> iso8601basic
> iso8601bas
> iso8601alternative
> iso8601alt
> iso8601extended
> iso8601ext
>
> The reason for allowing shorter names is to simplify database
> management for anyone who may need to store the format name in a column for
> some reason (I can't think of one now, but I get a feeling that someone
> will want to do this type of thing in the future).
>
> For that matter, the first letter could be used instead of the first
> three for the short versions. Any thoughts on this?
Just go with the full spellings.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-12-11 01:32:10 | SQLCourse.com |
Previous Message | Rod Taylor | 2003-12-07 21:12:54 | Oracle to PostgreSQL migration |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-12-09 23:37:59 | Re: add column sillyness |
Previous Message | Bryan Encina | 2003-12-09 23:06:05 | Re: PostgreSQL Training |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-12-09 23:50:12 | Re: ERROR: Index pg_toast_8443892_index is not a btree |
Previous Message | Robert Treat | 2003-12-09 22:43:49 | Re: PostgreSQL port to pure Java? |
From | Date | Subject | |
---|---|---|---|
Next Message | Claudio Natoli | 2003-12-10 00:27:36 | Re: Comments requested on attached fork/exec patch |
Previous Message | Bruce Momjian | 2003-12-09 23:26:33 | Re: [BUGS] (Modified) Patch request for PostgreSQL 7.4 for |