Re: ISO 8601 'Time Intervals' of the 'format with time-unit
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Randolf Richardson <rr@8x.ca>
Cc: pgsql-patches@postgresql.org
Date: 2003-12-09T23:28:20Z
Lists: pgsql-hackers
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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073