Re: T is a mandatory date time separator in RFC3339 but documentation states differently - Mailing list pgsql-docs

From Tom Lane
Subject Re: T is a mandatory date time separator in RFC3339 but documentation states differently
Date
Msg-id 2037453.1699892596@sss.pgh.pa.us
Whole thread Raw
In response to Re: T is a mandatory date time separator in RFC3339 but documentation states differently  (Erik Wienhold <ewie@ewie.name>)
Responses Re: T is a mandatory date time separator in RFC3339 but documentation states differently
List pgsql-docs
Erik Wienhold <ewie@ewie.name> writes:
> On 2023-11-13 15:24 +0100, Erik Wienhold wrote:
>> I also noticed that when people say "ISO 8601" they usually mean RFC
>> 3389 or some subset of ISO 8601.

> Forgot this fine visualization of the differences:
> https://ijmacd.github.io/rfc3339-iso8601/

I'm inclined not to change anything here, for a couple of reasons:

1. PG accepts a fairly large number of ISO 8601 variants (not all);
not only the RFC 3339 format.  So s/ISO 8601/RFC 3339/g would be
incorrect.  Besides, I think more people know what ISO 8601 is than
know what RFC 3339 is, so that change would also be confusing.

2. If ijmacd's pretty graphic is correct, then what we say about
'T' versus space is correct, even if it isn't the whole truth.
I'm not quite sure that ijmacd is correct, though, because of
this bit in 3339:

      NOTE: Per [ABNF] and ISO8601, the "T" and "Z" characters in this
      syntax may alternatively be lower case "t" or "z" respectively.

which suggests that 8601 is also case-insensitive.  I don't plan
to go buy a copy of that spec to find out, though.  In any case,
we accept 'T', 't', '_', and most other punctuation there, so
we should be able to read nearly any plausible variant.

            regards, tom lane



pgsql-docs by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: T is a mandatory date time separator in RFC3339 but documentation states differently
Next
From: Bruce Momjian
Date:
Subject: Re: 'pg_global' cannot be used as default_tablespace.