Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
Date: 2003-01-09 08:32:50
Message-ID: 200301090932.50971.ftm.van.vugt@foxi.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2003-01-09 08:52:35 Re: How can I do this?
Previous Message Shridhar Daithankar 2003-01-09 07:43:56 Re: dropping template1