Re: to_date problem. - Mailing list pgsql-bugs

lewwid <lewwid@telusplanet.net> 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