From: | Randolf Richardson <rr(at)8x(dot)ca> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' |
Date: | 2003-12-03 10:20:23 |
Message-ID: | Xns944615BC1835Brr8xca@200.46.204.72 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
[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?
--
Randolf Richardson - rr(at)8x(dot)ca
Vancouver, British Columbia, Canada
Please do not eMail me directly when responding
to my postings in the newsgroups.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-12-03 17:46:17 | Great article on OSS dev. |
Previous Message | Randolf Richardson | 2003-12-02 18:05:13 | Re: PostgreSQL Advocacy, Thoughts and Comments |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-12-03 10:21:10 | Re: DBD::Pg problem |
Previous Message | Ausrack Webmaster | 2003-12-03 09:43:22 | Re: DBD::Pg problem |
From | Date | Subject | |
---|---|---|---|
Next Message | John Sidney-Woollett | 2003-12-03 11:01:02 | Re: Transaction Question |
Previous Message | Shridhar Daithankar | 2003-12-03 09:16:30 | Re: *sigh* |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-03 15:49:01 | Re: Small documentation patch |
Previous Message | Christopher Kings-Lynne | 2003-12-03 07:34:57 | Re: Small documentation patch |