Re: ISO 8601 'Time Intervals' of the 'format with time-unit
От | Bruce Momjian |
---|---|
Тема | Re: ISO 8601 'Time Intervals' of the 'format with time-unit |
Дата | |
Msg-id | 200312092328.hB9NSKt18747@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators' (Randolf Richardson <rr@8x.ca>) |
Список | 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 it�s > > 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, I�d 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
В списке pgsql-patches по дате отправления: