Feedback-ID: ie0a040ee:Fastmail
Message-ID: <408aa3cd-0085-41c3-855c-3d51a1bc55d3@eisentraut.org>
Date: Wed, 15 Nov 2023 08:16:04 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: T is a mandatory date time separator in RFC3339 but documentation
 states differently
Content-Language: en-US
To: Erik Wienhold <ewie@ewie.name>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: =?UTF-8?Q?Roman_Fro=C5=82ow?= <rofrol@gmail.com>,
 pgsql-docs@lists.postgresql.org
References: <169974270449.398198.1438250797414790599@wrigleys.postgresql.org>
 <fojeaxd2hqux2abmft22nnsll435q2qfmecjlsig2g2th5u2bw@cr3m7rzgaop3>
 <CAFZ1f-9rnK6uZwsUUKDwCkNB9h9zP70oaSfduu+TxrQAxEmwjQ@mail.gmail.com>
 <CAFZ1f-9D3iCcGF8+mLgRffUp6i7m-2mh1GJ5UZbfcZiyjaXQzQ@mail.gmail.com>
 <piavtdd7mhmkpzpgvxaek3hz3e2kan3c2fitn5iqta6nyrpgyl@txongxshxkxw>
 <7njdkzeco47heg6tglzsm5wmmbb56vd66f7pta6gazb2k52viu@av3wruqnylpp>
 <2037453.1699892596@sss.pgh.pa.us>
 <d65bzp5h6j2lroyt3y4t7vlth76hdegjuh67dlsmxqzmzjbvtp@fdc4xs5awb3f>
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: <d65bzp5h6j2lroyt3y4t7vlth76hdegjuh67dlsmxqzmzjbvtp@fdc4xs5awb3f>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/408aa3cd-0085-41c3-855c-3d51a1bc55d3%40eisentraut.org>
Precedence: bulk

On 14.11.23 19:21, Erik Wienhold wrote:
> I did not say that occurrences of "ISO 8601" should be replaced with
> "RFC 3339".  Just that the docs should have a cautionary note about the
> SQL standard using a subset of ISO 8601 and that Postgres does not
> implement (at the moment) all of its date formats.

The SQL standard does not refer to ISO 8601 to define date formats, it 
has its own definitions.  In fact, PostgreSQL implements more date 
formats than the SQL standard requires.