Re: to_date conversion semantics?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Colin 't Hart" <colinthart(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: to_date conversion semantics?
Date: 2010-09-20 19:21:28
Message-ID: 15719.1285010488@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Colin 't Hart" <colinthart(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2010-09-20 19:27:10 Re: to_date conversion semantics?
Previous Message Aram Fingal 2010-09-20 19:20:59 Re: Installing Contrib Modules with a Precompiled Binary