Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Date
Msg-id CAKFQuwYpm+YJ-T6gfP+JTKKYKE7_GkRepfTMNS_RViQ+3JR3vA@mail.gmail.com
Whole thread Raw
In response to Re: TO_DATE Function unintended behavior when month value is greaterthan 12  (Pantelis Theodosiou <ypercube@gmail.com>)
Responses Re: TO_DATE Function unintended behavior when month value is greaterthan 12  (naidu rongali <rongalinaidu@gmail.com>)
List pgsql-bugs
Tree view

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: Pantelis Theodosiou
Date:
Subject: Re: TO_DATE Function unintended behavior when month value is greaterthan 12
Next
From: David Steele
Date:
Subject: Re: Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug