Re: TO_DATE Function unintended behavior when month value is greaterthan 12 - Mailing list pgsql-bugs

From naidu rongali
Subject Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Date
Msg-id CACu6o4o_i3oBbqTeb7jKWJ=Z-uda45LbCYaPzx9LayEkozFcfQ@mail.gmail.com
Whole thread Raw
In response to Re: TO_DATE Function unintended behavior when month value is greaterthan 12  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Thank you all for the update. I checked the version details.  it is "PostgreSQL 8.0.2". 

On Fri, Mar 2, 2018 at 1:13 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:

The error is thrown in version 10 but I get the wrong results in versions 9.3 to 9.6, both in the almost latest (9.3.21, 9.4.16, 9.5.11 and 9.6.7) and today's releases (9.3.22, ..., 9.6.8)


​As Pavel said we fixed this in 10 but did not back-patch the behavior change.

David J.

pgsql-bugs by date:

Previous
From: David Steele
Date:
Subject: Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug
Next
From: "David G. Johnston"
Date:
Subject: TO_DATE Function unintended behavior when month value is greater than 12