Re: ISO 8601 'Time Intervals' of the 'format with time-unit

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

In response to

Browse pgsql-advocacy by date

  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

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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?

Browse pgsql-patches by date

  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