"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> We just stopped doing this "shift-by-one" in probably the one arguable case
> where doing so made sense.
> https://github.com/postgres/postgres/commit/489c9c3407cbfd473c2f8d7863ffaaf6d2e8fcf8
Hmm, yeah, we should have suggested to_date as an alternative. Its use
of a format string makes the parsing problem more tractable.
regards, tom lane