Re: 8.5.1. Date/Time Input

From: Kacper Kuras <kacperkuras(at)hotmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: 8.5.1. Date/Time Input
Date: 2026-09-18 14:50:20
Message-ID: VI0P193MB3111F91B790EDF55FF2FD994BF872@VI0P193MB3111.EURP193.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Thanks. In the patch, "without a sign" only holds for years after
9999: dropping the minus from -0001-01-02 gives 0001-01-02, which is
1 AD, not 2 BC. Perhaps:

(ISO 8601 writes years after 9999 with a leading plus sign, and
years before 1 AD from a year zero, so 0000 is 1 BC and -0001 is
2 BC. PostgreSQL accepts neither; write 10000-01-02 and
0002-01-02 BC instead.)

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2026-09-18 15:48:53 Re: 8.5.1. Date/Time Input
Previous Message Bruce Momjian 2026-09-17 19:55:07 Re: 8.5.1. Date/Time Input