Re: Date/Time parsing of ISO 8601 timestamps with commas
| От | David G. Johnston |
|---|---|
| Тема | Re: Date/Time parsing of ISO 8601 timestamps with commas |
| Дата | |
| Msg-id | CAKFQuwakZz36PL_f09OQQOn5U3kdt13=n8iz+1WfuBbDjvuBDg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Date/Time parsing of ISO 8601 timestamps with commas (Nathan Bossart <nathandbossart@gmail.com>) |
| Ответы |
Re: Date/Time parsing of ISO 8601 timestamps with commas
|
| Список | 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 по дате отправления: