From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Erik Wienhold <ewie(at)ewie(dot)name> |
Cc: | Roman Frołow <rofrol(at)gmail(dot)com>, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: T is a mandatory date time separator in RFC3339 but documentation states differently |
Date: | 2023-11-13 16:23:16 |
Message-ID: | 2037453.1699892596@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Erik Wienhold <ewie(at)ewie(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2023-11-13 19:28:05 | Re: Version 14/15 documentation Section "Alter Default Privileges" |
Previous Message | Erik Wienhold | 2023-11-13 14:29:35 | Re: T is a mandatory date time separator in RFC3339 but documentation states differently |