lewwid <[EMAIL PROTECTED]> writes:
> select to_date('January 12 2002','Month dd yyyy');
> to_date
> ------------
> 0005-06-24 <----- Problem right there.
I think you need FM:
regression=# select to_date('January 12 2002','FMMonth dd yyyy');
to_date
------------
2002-01-12
(1 row)
Without that, the to_date scanner assumes it should be dealing with
fixed-width fields. I think this is moderately broken myself, but
maybe that's the way Oracle does it...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
