Re: Problem with zero year - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with zero year
Date
Msg-id 10562.1237308848@sss.pgh.pa.us
Whole thread Raw
In response to Problem with zero year  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Problem with zero year  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> The problem is that the 2-digit year check is for <=2 digits, not
> exactly two digits:
> ...
> This leads to some unexpected outputs:

>     test=> select '1-1-0'::date;
>        date
>     ------------
>      2000-01-01

We've interpreted that like that since 7.4, without complaints; and
I think it was an intentional change then (since 7.3 doesn't accept it).
I do not recommend changing it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Solaris getopt_long and PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Solaris getopt_long and PostgreSQL