Erik Wienhold <e...@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