"Peter Haworth" <[EMAIL PROTECTED]> writes:
> On Wed, 18 Jun 2003 15:09:44 -0600 (MDT), scott.marlowe wrote:
>> Why not accept a date of 04/44/2003 and just wrap it into May?
> Unbelievably, to_date() already does that in 7.3.3:
It's only "unbelievable" if Oracle doesn't do the same thing. to_date
and friends are Oracle compatibility functions and are intended to
slavishly imitate what Oracle does, warts and all (and there are
certainly plenty of warts there...)
Anyone care to run some tests to see how lax Oracle's to_date is?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
