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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: dropping template1
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: How can I do this?