Re: Date/Time parsing of ISO 8601 timestamps with commas - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Date/Time parsing of ISO 8601 timestamps with commas
Date
Msg-id CAKFQuwakZz36PL_f09OQQOn5U3kdt13=n8iz+1WfuBbDjvuBDg@mail.gmail.com
Whole thread Raw
In response to Re: Date/Time parsing of ISO 8601 timestamps with commas  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Date/Time parsing of ISO 8601 timestamps with commas
List pgsql-bugs
On Fri, Oct 10, 2025 at 4:09 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
On Fri, Oct 10, 2025 at 10:43:04AM +1100, Zane Duffield wrote:
> I noticed today that PostgreSQL doesn't support parsing ISO 8601 timestamps
> that use a comma as the decimal separator.

I found various threads about this in the archives, including this one:

        https://postgr.es/m/flat/152271186941.1442.12179299369295226185%40wrigleys.postgresql.org


If there are indeed various threads we might want to update the documentation to make it clear that we say "almost" because we don't correctly interpret formats that have substituted a comma for a full-stop. (And maybe other exceptions.)

Or, I suppose, Appendix B.1 step 1 should include a 5th note (or maybe add a step 0): "If the token is a comma it is replaced by a space".

David J.

pgsql-bugs by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Date/Time parsing of ISO 8601 timestamps with commas
Next
From: Zane Duffield
Date:
Subject: Re: Date/Time parsing of ISO 8601 timestamps with commas