Horton
Menu

Re: to_date conversion semantics?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Colin 't Hart" <colinthart@gmail.com>
Cc: Adrian Klaver <adrian.klaver@gmail.com>, pgsql-general@postgresql.org
Date: 2010-09-20T19:21:28Z
Lists: 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