"Colin 't Hart" <colinthart@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general