Re: to_date conversion semantics? - Mailing list pgsql-general

From Tom Lane
Subject Re: to_date conversion semantics?
Date
Msg-id 15719.1285010488@sss.pgh.pa.us
Whole thread Raw
In response to Re: to_date conversion semantics?  ("Colin 't Hart" <colinthart@gmail.com>)
List pgsql-general
"Colin 't Hart" <colinthart@gmail.com> writes:
> The 32nd of Undecember (!) turning into the 1st of February of the
> next year... instead of throwing an exception like I expect.

As mentioned previously, to_date isn't the tool to use if you want
a strict conversion --- it's designed to be rather, um, liberal.
Some people think that accepting dates like June 31st is a feature.

            regards, tom lane

pgsql-general by date:

Previous
From: Aram Fingal
Date:
Subject: Re: Installing Contrib Modules with a Precompiled Binary
Next
From: Richard Huxton
Date:
Subject: Re: to_date conversion semantics?