Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
От | Frank van Vugt |
---|---|
Тема | Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input |
Дата | |
Msg-id | 200301090932.50971.ftm.van.vugt@foxi.nl обсуждение исходный текст |
Ответы |
Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
|
Список | pgsql-general |
L.S. Problem: The date/time type in version 7.3.1 separates the two pieces of information in a combined date/time field with the character <space>. IMHO this is the preferable way for output, but it would be nice when one could use the formal ISO 8601 specification for input as well, instead of having to use the same <space character>. Data: The ISO8601 specification (ref.nr. ISO/TC 154 N 362 dated 2000-12-19) in paragraph 5.1.2 (page 10) describes the use of designators. It states that the character <T> is used as time designator for (amongs other things): "the start of the representation of the time of day in combined date and time expressions" Paragraph 5.4.1 (page 18) mentions the following note: "By mutual agreement of the partners in information interchange, the character [T] may be omitted in applications where there is no risk of confusing a combined date and time of the day representation with others defined in this International Standard." Request: Please allow input of the form "1997-12-17T07:37:16-08" as well as "1997-12-17 07:37:16-08" -- Regards, Frank van Vugt
В списке pgsql-general по дате отправления: