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