With Oracle (at least since 6.x version) this conversion is wrong.
Atentamente , Ariel Carná -----Mensaje original----- De: Tom Lane [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 27 de Abril de 2005 11:54 a.m. Para: Michael Fuhr CC: Ariel E. Carná/Elizabeth Sosa; pgsql-bugs@postgresql.org Asunto: Re: [BUGS] BUG #1630: Wrong conversion in to_date() function. See example. Michael Fuhr <[EMAIL PROTECTED]> writes: > If anything I'd expect 2005-02-32 to be rejected as invalid, but I > don't know the history or rationale behind to_date's behavior. It is rejected by the standard date input converter: regression=# select '2005-02-32'::date; ERROR: date/time field value out of range: "2005-02-32" HINT: Perhaps you need a different "datestyle" setting. However we consider that to_date() exists to be Oracle compatible, and so I would regard this as a bug if and only if Oracle does something different with the same input. Anyone know? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
