Re: 8.5.1. Date/Time Input - Mailing list pgsql-docs

From Kacper Kuras
Subject Re: 8.5.1. Date/Time Input
Date
Msg-id VI0P193MB3111F91B790EDF55FF2FD994BF872@VI0P193MB3111.EURP193.PROD.OUTLOOK.COM
Whole thread
In response to Re: 8.5.1. Date/Time Input  (Bruce Momjian <bruce@momjian.us>)
Responses Re: 8.5.1. Date/Time Input
Re: 8.5.1. Date/Time Input
List 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.)


pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 8.5.1. Date/Time Input
Next
From: Bruce Momjian
Date:
Subject: Re: 8.5.1. Date/Time Input