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

From Frank van Vugt
Subject Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
Date
Msg-id 200301090932.50971.ftm.van.vugt@foxi.nl
Whole thread Raw
Responses Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
List 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 by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: dropping template1
Next
From: Manfred Koizar
Date:
Subject: Re: How can I do this?