Michael Fuhr <mike(at)fuhr(dot)org> 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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-04-27 14:57:42|
|Subject: Re: BUG #1629: subquery IN returns incorrect results |
|Previous:||From: Juan Miguel Paredes||Date: 2005-04-27 14:50:23|
|Subject: Re: BUG #1630: Wrong conversion in to_date() function. See example.|