Frank Bax <fbax@sympatico.ca> writes:
> That's weird, because on my system to_date('31/12/2005','mm/dd/yyyy')
> produces 2007-07-14!
Yeah, to_date()'s lack of error checking is disgraceful. For most
purposes, it'd be better to read this data using the normal date
input converter with DATESTYLE set to DMY (or MDY if that's what you
really wanted).
regards, tom lane